Problems updating a table since users are logged on.

[Guest]

My problem is this.

I have a Table that needs updating, but it seems it cannot be done since
other people in my company are logged on. It would be easy to do this if
people would just log off, but the amount of accounts logged in makes it hard
to get them all to log off. Is there a way to set this to be "one user"? We
have user accounts that are connected to different groups. I realy need to
make it impossible for people to login on for a while.

Regards Perag

 

[Arvin Meyer [MVP]]

You should be able to edit a table with others logged into the database. I
have over 50 logged in without problems. Make sure that everyone has Shared
logon:

Tools ... Options ... Advanced tab, the Default Open made should be Shared.
Also make sure that the locking is set to either No Locks or Edited Record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

My problem is this.

I have a Table that needs updating, but it seems it cannot be done
since other people in my company are logged on. It would be easy to
do this if people would just log off, but the amount of accounts
logged in makes it hard to get them all to log off. Is there a way to
set this to be "one user"? We have user accounts that are connected
to different groups. I realy need to make it impossible for people to
login on for a while.

Regards Perag

Take a look at:

http://support.microsoft.com/?id=128814

or:

http://www.datastrat.com/Download2.html