I Dont Have Rights

D

DS

All of a sudden everytime I go to make changes in my database I get a
mesage that I don't have exclusive rights.... This is a database in
development on a stand alone machine. Whats going on?????
Thanks
DS
 
V

Van T. Dinh

* Close the database and exit from Access.
* Check and ensure that MSAccess.exe is not in the memory of your PC (just
in case that there is a "dead" instance of Access still connecting to the
database). Alternatively, you can reboot your PC to clear the memory.
* Check the directory where the Dabase file with MDB extension resides. In
your find a file {databaseName}.LDB (which is a locking file), delete this
file. Make sure you don't delete the MDB file.
* Try to open the database again and see if you can modify.

HTH
Van T. Dinh
MVP (Access)
 
D

DS

Van said:
* Close the database and exit from Access.
* Check and ensure that MSAccess.exe is not in the memory of your PC (just
in case that there is a "dead" instance of Access still connecting to the
database). Alternatively, you can reboot your PC to clear the memory.
* Check the directory where the Dabase file with MDB extension resides. In
your find a file {databaseName}.LDB (which is a locking file), delete this
file. Make sure you don't delete the MDB file.
* Try to open the database again and see if you can modify.

HTH
Van T. Dinh
MVP (Access)
Well can't seem to find an LDB file anywhere. But now its stopped.
Go Figure!
Thanks
DS
 
V

Van T. Dinh

Yes. It is entirely possible that a subsequent opening and closing of the
database will clear the LDB and exclusive/shared won't be a problem after
that.
 
D

DS

Van said:
Yes. It is entirely possible that a subsequent opening and closing of the
database will clear the LDB and exclusive/shared won't be a problem after
that.
Thanks.
DS
 
Top