Automation error

[rtdc]

I have an issue with a Access 2007 runtime installed database, this file works perfectly on most machines except two and even on them it will not if full Access.

It uses a connection to SQL server to get its data which works as the database opens and allows interrogation of the tables via forms. The trouble starts when it tries to open an Access report I get this message: -

Error: - 2147024770 Automation error
The Specified module could not be found

I have googled this and no answers are apparent. As the code works on all other machines and the same users can use the file perfectly on other machines I have ruled out the database at fault or user permissions.

I am thinking that something is missing from the machine, another package that gives Dll’s that Access needs but I cannot see what that might be. The package was installed with the vbsendmail.dll which I have registered to with no change.

Has anyone come across anything similar? Any ideas?

 

[jamesmor]

First I'd check your references.

Then go over your code for that report and try your best to isolate the line/lines that throw the error. That should give you a better idea where to start from.

 

[rtdc]

I have checked my references and all are fine (According to Access) and stepped through the code, it breaks at ADOX.catalog however the code works on all the other machines Win XP and Windows 7 alike.

I think missing library even though it says all present but even though i have tried i cannot isolate what is missing.

 

[jamesmor]

Time to start checking your versions on your libraries, if for some reason those machines have an older version that might be your problem. I've had that problem before.

 

[rtdc]

Good plan, I have installed Access 2007 run time and full blown later for debugging but it does have Access 2000 on board to. I will check all the library ages on Monday, it has to be something to do with them.

Cheers..

 

[rtdc]

I have checked all the libaries used and all are fine, some are newer on the non working machine though. Does that matter?

This has got me stumped, if it didn't work full stop then yes i could fix it but the fact it works elsewhere fine is odd. The report it is trying to open will open if done direct it seems to fail on set ADOX.Catalog

Any ideas?

 

[jamesmor]

any chance you can post the offending code?

 

[gemma-the-husky]

I have an issue with a Access 2007 runtime installed database, this file works perfectly on most machines except two and even on them it will not if full Access.

are you saying these machines wont run the dbs properly with full access?

then its almost certainly nothing to do with the runtime - its something to do with the installation/settings on those computers, or windows or similar.

 

[rtdc]

It is something wrong on the PC itself as the db doesn't run even in full blown access but works fine eleswhere, I have tested all the libaries, installed access extras and compared the pc to working ones, I can't see anything wrong its one of those stinkers.