Cancelado

Solve perplexing MS Access behaviour(repost)

I have a MS Access database.

If I save it in a particular directory (in this case, but not always "C:\Documents and Settings\Jason\Application Data\ESdat\Sample Contam") and I link to the tables from another (new/blank) .mdb database I get a very fatal crash when running the following ado command on the new database (bypasses normal error handling). This happens on multiple PC's (where I had to generate that path manually)

Set rsTableSchema = [url removed, login to view](adSchemaForeignKeys)

--See attached Excel for the code in VBA.

If I copy the database to a different directory (ie not "C:\Documents and Settings\Jason\Application Data\ESdat\Sample Contam") , and then link to the tables the OpenSchema command works fine.

I need someone to:

Create the folder structure indicated above. ("C:\Documents and Settings\Jason\Application Data\ESdat\Sample Contam")

Save the provided database into that folder

Link the tables to a new, blank mdb database.

Run the code in the attached Excel Workbook (ie the OpenSchema code).

Confirm that this crashes Excel.

Then repeat, but with the provided database is a different folder.

Link the tables to a new, blank mdb database.

Confirm that this doesn't crash Excel.

I then need a code based resolution (VBA is fine) leaving the database in the same folder.

## Deliverables

* * *This broadcast message was sent to all bidders on Wednesday Dec 22, 2010 9:34:15 PM:

This is a re-post of the project. It was awarded but the winner could replicate but not solve the issue and cancelled after only some hours. Please, only people who can replicate the issue should bid.

Habilidades: Arquitetura de software, Área de trabalho do Windows

Ver mais: ms access excel vba, i was awarded, vba error, vba create folder, create folder vba, ms access 2010, vba access excel, solve, solve some, software dec, ms access, ms access vba, MS Access Database, behaviour, ACCESS VBA, project database vba excel, bid vba project, vba excel copy, 2010 access, vba post, application vba, hours access database, access 2010 application, access 2010 project, windows crash

Acerca do Empregador:
( 25 comentários ) Ballina, Australia

ID do Projeto: #2996196

5 freelancers estão ofertando em média $232 para este trabalho

gribfritz

See private message.

$242.25 USD in 7 dias
(477 Comentários)
7.6
suryavijayvw

See private message.

$321.3 USD in 7 dias
(107 Comentários)
5.5
dumbraveanualin

See private message.

$212.5 USD in 7 dias
(23 Comentários)
4.7
vw7282474vw

See private message.

$255 USD in 7 dias
(2 Comentários)
1.9
sergeberg

See private message.

$127.5 USD in 7 dias
(0 Comentários)
0.0
techinvention

See private message.

$212.5 USD in 7 dias
(2 Comentários)
0.0