Exclusive Access Clois Beckwith 19.09.2006 13:35:02 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.

Re: Exclusive Access "Joan Wild" <jwild[ at ]nospamtyenet.com> 19.09.2006 14:14:39 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: [Quoted Text] > 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.

Re: Exclusive Access Clois Beckwith 19.09.2006 15:12:02 There is NOT an Ldb in the server location where the frontend and backend are located. "Joan Wild" wrote: [Quoted Text] > 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. > > >

Re: Exclusive Access "Joan Wild" <jwild[ at ]nospamtyenet.com> 19.09.2006 15:33:50 What is the text of the message you get? -- Joan Wild Microsoft Access MVP Clois Beckwith wrote: [Quoted Text] > 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.

Re: Exclusive Access Clois Beckwith 19.09.2006 16:56:02 can't open database in exclusinve mode because a user is logged in or I don't have exclusive rights. "Joan Wild" wrote: [Quoted Text] > 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. > > >

Re: Exclusive Access "Joan Wild" <jwild[ at ]nospamtyenet.com> 19.09.2006 20:35:28 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: [Quoted Text] > 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.

Re: Exclusive Access Clois Beckwith 27.09.2006 13:32:01 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: [Quoted Text] > 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. > > >

Re: Exclusive Access "Joan Wild" <jwild[ at ]nospamtyenet.com> 27.09.2006 17:24:07 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: [Quoted Text] > 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.

Re: Exclusive Access Clois Beckwith 27.09.2006 17:42:01 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: [Quoted Text] > 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. > > >

Re: Exclusive Access "Joan Wild" <jwild[ at ]nospamtyenet.com> 28.09.2006 16:06:36 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) -- Joan Wild Microsoft Access MVP Clois Beckwith wrote: [Quoted Text] > 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.