View Full Version : Microsoft Access (Office 97)

14-09-2002, 10:34 AM
I have recently changed my motherboard to an Asus A7V255. My System is windows ME.
The Problem is with reteiving and adding data to my database in access. I keep on getting the error message "The Microsoft Jet Engine cannot open file dbase/dbase.mdb. It is already opened by another user, or you need permission to view its data.
I am the only user of this database, and it consists of my book and cd collections, over 10,000 entries which I do not want to re-enter.

Is there any way to correct this problem and be able to enter and change the DB again?
Alan Rutherford

14-09-2002, 11:39 AM
Hi Rutherford. Is there a file dbase.ldb in the same folder as dbase.mdb? When opening Access it locks the database via the creation of a ldb file so this could be the problem if the file exists but the database is closed.

See if you can copy the database to another folder then delete the ldb file if it exists.

If this file isnt there then I would try repairing Access - theres an option for repairing the installation on the Office CD.


14-09-2002, 07:35 PM
Have you tried the 'repair database' option?

You could also try creating a new (empty) database and see if you can import the objects from your current database into it.

14-09-2002, 08:17 PM
when you changed motherboard did you reinstall windows?

15-09-2002, 01:47 PM
Thank you for your reply. I couln't find the file you mentioned, and repair didn't. I finally found that the answer was to go to tools, options, advanced and tick ignore DDE requests. Hey Presto it worked.

Alan Rutherford

15-09-2002, 01:49 PM
I tried the repair option but it didn't work. I finally found the answer was to goto tools, options, advanced and tick the ignore DDE request. Thank you for trying to help me.

Alan Rutherford

15-09-2002, 01:51 PM
Yes I installed windows and office. I finally found the solution was to goto tools, options, advanved and tick ignore DDE request.

Alan Rutherford