 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / September 2006Exclusive Access
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. 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 >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 [quoted text clipped - 6 lines] > exclusive rights. I am stumped, no one is in the database, either in the > front end or the backend. Any Ideas. 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.  SignatureJoan Wild Microsoft Access MVP > 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 [quoted text clipped - 4 lines] > one is in the database, either in the front end or the backend. Any > Ideas. There is NOT an Ldb in the server location where the frontend and backend are located. > 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 [quoted text clipped - 8 lines] > > one is in the database, either in the front end or the backend. Any > > Ideas. What is the text of the message you get? SignatureJoan Wild Microsoft Access MVP > There is NOT an Ldb in the server location where the frontend and > backend are located. [quoted text clipped - 15 lines] >>> I am stumped, no one is in the database, either in the front end or >>> the backend. Any Ideas. can't open database in exclusinve mode because a user is logged in or I don't have exclusive rights. > What is the text of the message you get? > [quoted text clipped - 17 lines] > >>> I am stumped, no one is in the database, either in the front end or > >>> the backend. Any Ideas. 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. SignatureJoan Wild Microsoft Access MVP > can't open database in exclusinve mode because a user is logged in or > I don't have exclusive rights. [quoted text clipped - 24 lines] >>>>> exclusive rights. I am stumped, no one is in the database, either >>>>> in the front end or the backend. Any Ideas. 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? > 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 [quoted text clipped - 28 lines] > >>>>> exclusive rights. I am stumped, no one is in the database, either > >>>>> in the front end or the backend. Any Ideas. 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? SignatureJoan Wild Microsoft Access MVP > 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 [quoted text clipped - 37 lines] >>>>>>> exclusive rights. I am stumped, no one is in the database, >>>>>>> either in the front end or the backend. Any Ideas. 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 > What is LDB.exe? I've never heard of that. > [quoted text clipped - 43 lines] > >>>>>>> exclusive rights. I am stumped, no one is in the database, > >>>>>>> either in the front end or the backend. Any Ideas. 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) SignatureJoan Wild Microsoft Access MVP > 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 [quoted text clipped - 52 lines] >>>>>>>>> the database, either in the front end or the backend. Any >>>>>>>>> Ideas. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.