A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Locked out of my database



 
 
Thread Tools Display Modes
  #1  
Old October 6th, 2008, 03:54 PM posted to microsoft.public.access
Rpettis31
external usenet poster
 
Posts: 96
Default Locked out of my database

I have an open database that I was reviewing to write up documentation.
I recently have tried to open the database to review some event code that
was in a form. The database says I do not have exclusive rights and yet it
thinks I am in the database from this message. I have logged out of my
machine only to find I am still in the program, how do I fix this issue?
  #2  
Old October 6th, 2008, 04:07 PM posted to microsoft.public.access
Chris O'C via AccessMonster.com
external usenet poster
 
Posts: 1,160
Default Locked out of my database

Either reboot the pc or log back into your account and open the task manager
and kill the msaccess.exe process.

But why do you need exclusive rights to review code and write documentation
for it? You only need exclusive rights when you're making design changes.

Chris
Microsoft MVP


Rpettis31 wrote:
I have an open database that I was reviewing to write up documentation.
I recently have tried to open the database to review some event code that
was in a form. The database says I do not have exclusive rights and yet it
thinks I am in the database from this message. I have logged out of my
machine only to find I am still in the program, how do I fix this issue?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

  #3  
Old October 6th, 2008, 04:28 PM posted to microsoft.public.access
Rpettis31
external usenet poster
 
Posts: 96
Default Locked out of my database

I needed the rights as I am cleaning up code that was not used as user needs
changed frequently during the development. Ironically, someone else had gone
into the database and was in it.

Thanks
Robert

"Chris O'C via AccessMonster.com" wrote:

Either reboot the pc or log back into your account and open the task manager
and kill the msaccess.exe process.

But why do you need exclusive rights to review code and write documentation
for it? You only need exclusive rights when you're making design changes.

Chris
Microsoft MVP


Rpettis31 wrote:
I have an open database that I was reviewing to write up documentation.
I recently have tried to open the database to review some event code that
was in a form. The database says I do not have exclusive rights and yet it
thinks I am in the database from this message. I have logged out of my
machine only to find I am still in the program, how do I fix this issue?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1


  #4  
Old October 6th, 2008, 04:40 PM posted to microsoft.public.access
Chris O'C via AccessMonster.com
external usenet poster
 
Posts: 1,160
Default Locked out of my database

Ok so your were really making design changes not just reviewing code.

But if someone else opened *your* front end it means you're sharing a db file
on the network. The db should be split into two files with tables and
relationships in the back end file saved on the network share and a copy of
the front end file (all other objects) on each user's desktop. You'll avoid
many chances of corruption and prevent many problems a shared environment
causes like not having exclusive access when you need it.

Chris
Microsoft MVP


Rpettis31 wrote:
I needed the rights as I am cleaning up code that was not used as user needs
changed frequently during the development. Ironically, someone else had gone
into the database and was in it.

Thanks
Robert

Either reboot the pc or log back into your account and open the task manager
and kill the msaccess.exe process.

[quoted text clipped - 10 lines]
thinks I am in the database from this message. I have logged out of my
machine only to find I am still in the program, how do I fix this issue?


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.