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 2007

Tip: Looking for answers? Try searching our database.

Only one user at time can open access file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hallgeir - 15 Jun 2007 11:53 GMT
We have an access file (.mdb) in a shared folder on the windows 2003 server.
Every user can access the file from the path "K:\Customer\Cust.mdb". Our
problem is that only one user at time is able to have the file open.
Cust.mdb starts ok for the first user, but when the second user tries to
double click the file nothing happens. It workes this way whoever person is
the first or second user.
Any suggestions? I don't even know if it is a Access problem or a network
problem.

Thanks!
Signature

regards
hallgeir

Rick Brandt - 15 Jun 2007 13:44 GMT
> We have an access file (.mdb) in a shared folder on the windows 2003
> server. Every user can access the file from the path
[quoted text clipped - 6 lines]
>
> Thanks!

Do all users have full permissions to the folder where the file resides?
They need it for proper creation, updating, and deletion of the locking
file.  If the locking file cannot be created by the first user then the file
is opened exclusively locking everyone else out.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Tom Wussernark [MSFT] - 26 Jun 2007 10:53 GMT
correction!

this information is a decade obsolete

you need to STFU and move to ADP, kid

>> We have an access file (.mdb) in a shared folder on the windows 2003
>> server. Every user can access the file from the path
[quoted text clipped - 11 lines]
> file.  If the locking file cannot be created by the first user then the
> file is opened exclusively locking everyone else out.
Tony Toews [MVP] - 26 Jun 2007 19:20 GMT
>correction!
>
>this information is a decade obsolete
>
>you need to STFU and move to ADP, kid

Note that this person is really A a r o n   K e m p f and that he is not an employee
of Microsoft.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
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.