access 2000 there was an error executing this command

[1bulldog007]

I have a shortcut to an .mde file that several people in my company use. There is a single computer in the company that cannot run the reports. A little back history.

The program is Access 2000. Access 2000 would not open because the system.mdw file was corrupted. I mistakenly assumed an uninstall and reinstall of Office 2000 would fix the issue (Outlook also had issues). It did not. I found a copy of the system.mdw in an i386 folder and copied the file into C:\program files\common files\system and renamed the old file. Access would open now but it will not run the .mde file. I copied the system.mdw file from a known working computer and was still unable to access the .mde file. I updated to SP3 with still no luck, checked the MDAC but it was running XP SP2 so those components were included. I have performed a compact and repair on the database with no luck as well. Access can open the sample databases. Any thoughts would be appreciated.

Thanks,

 

[1bulldog007]

By the way the error message states "There was an error executing this command." The switchboard tables are no different than other computers on which this works. Also, if not already indicated, I am not all that familiar with Access.

 

[1bulldog007]

Mods, please close this thread. The issue has since been resolved.