Having Only One User in Access

[Seth]

Hello,

I have an access XP DB that I would like to set up, so
that if someone is in it putting in information, no one
else can get into it until the person currently in it gets
out. This is to make sure that we don't give out
duplicate account numbers when setting new members up.

Any Help would be apprieciated,

Seth
P.S. I have tried to open the DB in exclusive mode, but
then another person could get right in, and modify the
table I was in, with no problem. thanks!

 

['69 Camaro]

Hi, Seth.

When you tried to open the DB in exclusive mode, did you use a shortcut to
open the database? If you fail to explicity identify the path and file name
of the Access executable in the shortcut, then Windows will ignore all of
the command-line switches and just use the Registry settings. For example,
a shortcut's target would need:

"<Full path to Office>\MSAccess.EXE" "<Full path to db>\MyData.MDB" /excl

In addition, you can open a database by opening Access, then selecting the
File menu -> Open, then browsing to your database file and selecting "Open
Exclusive," instead of "Open."


If you attempt to open a database exclusively and it has already been opened
in shared mode previously, then your session will also be opened in shared
mode.

You may want to look into a table lock to prevent your database from
creating duplicate account numbers. That way, multiple users can still use
the database, but only one user at a time can create a new account number in
the table. Implementing a table lock will require VBA, so the "open in
exclusive mode" technique is the most restrictive in a multi-user
environment, but also requires the least effort to implement.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)