Two Users Sharing a DB

M

Marco

Hi Everyone
I will have two users using one database over a LAN. The chance that we
will be in the same record, query or report at the same time is slim.
Do you suggest spilting the DB? Or will it run fine with us accessing
the same file?

Best Regards
Marco
www.classactinsurance.com
 
D

Douglas J. Steele

It's always better to split the application: it minimizes the chances of
corruption.
 
M

Marco

Is it better to set user-level Security first and then split or split
then set user-levels?
 
L

Larry Linson

Is it better to set user-level Security
first and then split or split then set
user-levels?
Click to expand...

Split, then set.

Be sure to get and study carefully the Security FAQ. Go to Advanced Search
at the Knowledge Base site, http://support.microsoft.com, and search within
the product "Access 2000" for "Access Security FAQ". Access' user and group
security is "decidedly non-trivial". Roger Jennings, in his Access 2.0
Developer Guide, characterized it as "labrynthine" and it has not gotten any
simpler.

Larry Linson
Microsoft Access MVP
 
Top