Move databse from one folder to another

M

MS Novice

I want to move a database from a subfolder to the primary folder (and rename
it). When I highlght the database then select move this file, I get an error
that the database is in use (which is also what I get when I try to rename).
I have restarted my computer and made that my first action upon logging on
and I get the same error. Your help is appreciated.
 
J

Jeff Boyce

First, try to make a backup.

In the same folder where your database resides (YourDB.mdb), is there also a
file named YourDB.ldb?

Microsoft Access uses an ".ldb" (locking database) file to keep track of
users. If Access has been shut down incorrectly (e.g., PC turned off while
Access was still running), the .ldb file may not have been removed, leaving
Access the impression that the file/database is still in use.

If you find a YourDB.ldb file, try deleting it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top