N/APosted on - 05/05/2012
My computer is giving me the error message “there was an error executing the command” on using the database Access 97 database and oracle database. I have created about 200 reports and queries and there are 30+ users who are using these reports daily without any problem. I am using Windows 7 and Access 97. The database is shared on a network drive, but even after copying it to my computer desktop it does not stop in giving this error. It works fine with other users and computers but in this machine it is having trouble. Can anyone help me fix this issue?
Thank you in Advance
Access 97 database and oracle database Error
I feel that your computer is missing some DLL files. Perhaps your machine does not have all the software installed that are required. See the machine where it is working, there must be some software installed that is not in your machine.
Further it may happen that 97 Access is creating problems with Windows 7 O S. Make sure all other systems working are using the same O S.
I have known that if the database you are using is Access 97 then you should have installed Microsoft Access 2003 as the earliest version for all the features in Access 97 to work with.
Lastly, Install Access 2003 and try opening it from that version.