Exclusive Access

[Guest]

I am the administrator of the database, I am in the Admins Group with no
permissions for the Users group. When I try to open the backend or the
frontend in exclusive mode, it is set for Shared Access for the database. My
log-in pops up, I enter my password and click OK, it comes back with " can't
open database in exclusinve mode because a user is logged in or I don't have
exclusive rights. I am stumped, no one is in the database, either in the
front end or the backend. Any Ideas.

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[Joan Wild]

When the database is closed, and no one else is in it, open Windows Explorer
and see if there is a ldb file in the same folder as the mdb. If you see
it, delete it. Try opening the mdb again.

 

[Guest]

There is NOT an Ldb in the server location where the frontend and backend are
located.

 

[Joan Wild]

What is the text of the message you get?

 

[Guest]

can't open database in exclusinve mode because a user is logged in or I
don't have exclusive rights.

 

[Joan Wild]

I have not heard of a message with that particular text. If you are certain
that no one else has the database open, then I am unsure of what else it
could be.

 

[Guest]

I am back to the LDB issue now, when I logged in and checked the LDB with
Office 97 file LDB.exe it is NOT seeing the machine that is logged into the
database. Any ideas?

 

[Joan Wild]

What is LDB.exe? I've never heard of that.

When you log in, open Windows Explorer and go to the folder where the mdb is
located. You should see a file with the same name as the mdb, but a ldb
extension. Do you?

 

[Guest]

It is there, but when I use the Office97 - LDB.exe file that came under
Office97, it does not see the users that are on-line with the database open

 

[Joan Wild]

Is this a single mdb or a split one?

If it's split, opening the frontend isn't necessarily enough to open the
backend; open a linked table.

You can also open the ldb in notepad to see who has it open; note that it'll
show any user that has had it open since the ldb was first created - they
may have logged out, but the ldb will still show them.

(never heard of ldb.exe)