Error with Access object

[rixx]

I am trying to run a couple of reports in Access from a VB6 app. I am able to run it fine on my machine, however when I install it on another machine, I get a Windows error saying that my executable caused a problem and the app shuts down (much like the IE error asking to send/don't send report. The ModName on the error says rpcrt.4dll. I set a reference to Microsoft Access 10.0 Object Library and I'm using Access XP. The other machines are using Access 2000. The program bombs when I do the following:

Set oAccess = New Access.Application
' Open Database
oAccess.OpenCurrentDatabase (MyDB)

I would appreciate any help. This is a time-sensitive issue because I need to fix this ASAP.

Thanks in advance,

Rick

 

[zarkon4]

You may try to reference Access 9.0 if you are running the app on machines with Access 2000. You may also have to have both Access Xp and 2000 on your development machine.

 

[rixx]

I will try that. Thanks for the help. I'll keep you posted and let the forum know if it works.

rixx