Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2005

Tip: Looking for answers? Try searching our database.

More than one user connected to same Access DB simultaneously

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Absar Ahmad - 23 Jun 2005 10:10 GMT
Can more than one user connect to same Access DB simultaneously?
Tom Lake - 23 Jun 2005 11:53 GMT
> 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
Larry  Linson - 23 Jun 2005 23:12 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.