Two Users Sharing a DB

[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

 

[Douglas J. Steele]

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

 

[Marco]

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

 

[Larry Linson]

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

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