|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Exclusive AccessI 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 Show quoteHide quote "Clois Beckwith" <CloisBeckw***@discussions.microsoft.com> wrote in message news:00B940E5-FE55-4620-B3ED-EA8CEC738D49@microsoft.com... >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. > 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. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Clois Beckwith wrote: > 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. There is NOT an Ldb in the server location where the frontend and backend are
located. Show quoteHide quote "Joan Wild" wrote: > 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. > > -- > Joan Wild > Microsoft Access MVP > > Clois Beckwith wrote: > > 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. > > > What is the text of the message you get?
-- Show quoteHide quoteJoan Wild Microsoft Access MVP Clois Beckwith wrote: > There is NOT an Ldb in the server location where the frontend and > backend are located. > > > "Joan Wild" wrote: > >> 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. >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Clois Beckwith wrote: >>> 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. can't open database in exclusinve mode because a user is logged in or I
don't have exclusive rights. Show quoteHide quote "Joan Wild" wrote: > What is the text of the message you get? > > -- > Joan Wild > Microsoft Access MVP > > Clois Beckwith wrote: > > There is NOT an Ldb in the server location where the frontend and > > backend are located. > > > > > > "Joan Wild" wrote: > > > >> 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. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Clois Beckwith wrote: > >>> 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. > > > 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. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Clois Beckwith wrote: > can't open database in exclusinve mode because a user is logged in or > I don't have exclusive rights. > > > "Joan Wild" wrote: > >> What is the text of the message you get? >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Clois Beckwith wrote: >>> There is NOT an Ldb in the server location where the frontend and >>> backend are located. >>> >>> >>> "Joan Wild" wrote: >>> >>>> 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. >>>> >>>> -- >>>> Joan Wild >>>> Microsoft Access MVP >>>> >>>> Clois Beckwith wrote: >>>>> 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. 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? Show quoteHide quote "Joan Wild" wrote: > 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. > > -- > Joan Wild > Microsoft Access MVP > > Clois Beckwith wrote: > > can't open database in exclusinve mode because a user is logged in or > > I don't have exclusive rights. > > > > > > "Joan Wild" wrote: > > > >> What is the text of the message you get? > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Clois Beckwith wrote: > >>> There is NOT an Ldb in the server location where the frontend and > >>> backend are located. > >>> > >>> > >>> "Joan Wild" wrote: > >>> > >>>> 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. > >>>> > >>>> -- > >>>> Joan Wild > >>>> Microsoft Access MVP > >>>> > >>>> Clois Beckwith wrote: > >>>>> 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. > > > 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? -- Show quoteHide quoteJoan Wild Microsoft Access MVP Clois Beckwith wrote: > 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" wrote: > >> 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. >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Clois Beckwith wrote: >>> can't open database in exclusinve mode because a user is logged in >>> or I don't have exclusive rights. >>> >>> >>> "Joan Wild" wrote: >>> >>>> What is the text of the message you get? >>>> >>>> -- >>>> Joan Wild >>>> Microsoft Access MVP >>>> >>>> Clois Beckwith wrote: >>>>> There is NOT an Ldb in the server location where the frontend and >>>>> backend are located. >>>>> >>>>> >>>>> "Joan Wild" wrote: >>>>> >>>>>> 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. >>>>>> >>>>>> -- >>>>>> Joan Wild >>>>>> Microsoft Access MVP >>>>>> >>>>>> Clois Beckwith wrote: >>>>>>> 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. 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 Show quoteHide quote "Joan Wild" wrote: > 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? > > > -- > Joan Wild > Microsoft Access MVP > > Clois Beckwith wrote: > > 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" wrote: > > > >> 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. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Clois Beckwith wrote: > >>> can't open database in exclusinve mode because a user is logged in > >>> or I don't have exclusive rights. > >>> > >>> > >>> "Joan Wild" wrote: > >>> > >>>> What is the text of the message you get? > >>>> > >>>> -- > >>>> Joan Wild > >>>> Microsoft Access MVP > >>>> > >>>> Clois Beckwith wrote: > >>>>> There is NOT an Ldb in the server location where the frontend and > >>>>> backend are located. > >>>>> > >>>>> > >>>>> "Joan Wild" wrote: > >>>>> > >>>>>> 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. > >>>>>> > >>>>>> -- > >>>>>> Joan Wild > >>>>>> Microsoft Access MVP > >>>>>> > >>>>>> Clois Beckwith wrote: > >>>>>>> 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. > > > 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) -- Show quoteHide quoteJoan Wild Microsoft Access MVP Clois Beckwith wrote: > 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" wrote: > >> 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? >> >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Clois Beckwith wrote: >>> 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" wrote: >>> >>>> 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. >>>> >>>> -- >>>> Joan Wild >>>> Microsoft Access MVP >>>> >>>> Clois Beckwith wrote: >>>>> can't open database in exclusinve mode because a user is logged in >>>>> or I don't have exclusive rights. >>>>> >>>>> >>>>> "Joan Wild" wrote: >>>>> >>>>>> What is the text of the message you get? >>>>>> >>>>>> -- >>>>>> Joan Wild >>>>>> Microsoft Access MVP >>>>>> >>>>>> Clois Beckwith wrote: >>>>>>> There is NOT an Ldb in the server location where the frontend >>>>>>> and backend are located. >>>>>>> >>>>>>> >>>>>>> "Joan Wild" wrote: >>>>>>> >>>>>>>> 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. >>>>>>>> >>>>>>>> -- >>>>>>>> Joan Wild >>>>>>>> Microsoft Access MVP >>>>>>>> >>>>>>>> Clois Beckwith wrote: >>>>>>>>> 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. |
|||||||||||||||||||||||
Other interesting topics