Error -2147221163 trying to automate Access XP

[Mike]

We are experiencing a problem automating Access XP from Access XP. We have an Access mde which is running using the run-time version of Access. This mde launches a new instance of access and then loads an Access mdb to print a report from the mdb and that is when the error below occurs. We have opened the mdb in Access and the report prints fine. We have checked the References and all are ok. This is only happening on one PC running Windows 2000 Pro, the other ten PC's are fine. The PC also has Office 2000 Pro on it

Error -2147221163 Method 'CurrentDB' of object '_Application' faile

We have tried the following without success

re-installing the Access runtim
installing the full version Access X
msaccess.exe /regserve
Detect and Repair in Acces

Has anyone got any ideas

 

[Yuan Shao]

Hello,

Thanks for your post. If I understand correctly that you encountered the
following error message when you worked with Access database.
"Error -2147221163 Method 'CurrentDB' of object '_Application' failed"

Please try manually registering the DAO360.dll file to see if it can fix
your problem:
1. Go to Start -> Search -> All Files and Folders, type regsvr32.exe in the
Search box. The file is located in winnt\system32 folder by default.

2. Bring up another Find box and search for the DAO360.dll file which is
located in Program Files\Common Files\Microsoft Shared\DAO folder by
default.

3. Drag the DAO360 file over on top of the REGSVR32 file to register it.

Thanks for posting in community.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Mike]

Thanks for the response, we are unable to try it out yet but will let you know of the outcome when we do.