Access 97 database and oracle database Error

Asked By belensienna 10 points N/A Posted on - 05/05/2012

Hello Everyone,

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

• Status: Open
• Question Views: 923
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Ratyr patsr 0 points N/A #141652

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.

 

About Ratyr patsr

Questions
0

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 05/10/2012
• Question Category: Oracle Database