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 / Setup / Configuration / February 2004

Tip: Looking for answers? Try searching our database.

Multiple Users

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian - 24 Feb 2004 21:36 GMT
I have created a small database that is meant to be
accessed by many people.  The people accessing it will not
be editing anything directly, just querying for
information based upon their input from Combo boxes.  For
some reason, I am unable to get two people onto it at the
same time.  I have the Default Open Mode set to shared yet
still get an "...Opened exclusively by another user..."  
error.  It is on a server that both people have write
access to.  I have other databases that are set up almost
identically as this one and they do not run into this
problem.  What could be the cause of this?  Are there any
interactions between forms and queries and tables that
could trigger this?  Any help, even list of things to look
at would be very much appreciated.  Thanks.
Joan Wild - 26 Feb 2004 22:05 GMT
Users should also have create and delete permissions on the folder.  Without
the create permission, the first person in can't create the associated ldb
file, and the mdb is opened exclusively.

Also you should split the database, leaving the backend on the server.  Give
each user a copy of the frontend on their workstation.

Signature

Joan Wild
Microsoft Access MVP

> I have created a small database that is meant to be
> accessed by many people.  The people accessing it will not
[quoted text clipped - 10 lines]
> could trigger this?  Any help, even list of things to look
> at would be very much appreciated.  Thanks.
 
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.