> Can more than one user connect to same Access DB simultaneously?
Yes. The only restriction is if one person is editing a record, another
person can just look at that record until the first person has saved it.
Tom Lake
> Can more than one user connect
> to same Access DB simultaneously?
Yes, but it is better and safer to store the data, tables, and relationships
on a shared folder in the network (called the back-end database), and give
each user a front-end database (queries, forms, reports, macros, modules)
that you link to the shared datatables.
There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.
Good luck.
Larry Linson
Microsoft Access MVP