Only one user at a time?

  • Thread starter Thread starter Sportster883
  • Start date Start date
S

Sportster883

How do I set up my database so only one user can enter data at a time? I was
told that is two users entered data into the same page at the same time and
saved I have a better than average chance my database will be currupted! My
database will be used by three offices in three locations so the possibility
exists that one, two, or three offices can have the databsae open at the same
time.
 
How do I set up my database so only one user can enter data at a time? I was
told that is two users entered data into the same page at the same time and
saved I have a better than average chance my database will be currupted!
Click to expand...

You were told a falsehood. Access is multiuser out of the box, and has a
robust and effective means of detecting data conflicts.
My
database will be used by three offices in three locations so the possibility
exists that one, two, or three offices can have the databsae open at the same
time.
Click to expand...

Ahhh... but if these are different locations, connected by a Wide Area
Network, then Access is NOT the ideal tool. It's simply not designed to work
over the internet. The problem isn't multiuser, it's the remote connection.
See

http://members.shaw.ca/AlbertKallal/Wan/Wans.html


You may want to consider storing the data in SQL/Server (SQL/Server Express is
fairly economical, i.e. free) using Access as a remote frontend.
 
Back
Top