Only one user at time can open access file "Hallgeir" <hallgeir[ at ]unittakeawayechsys.no> 6/15/2007 10:53:51 AM 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! -- regards hallgeir

Re: Only one user at time can open access file "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 6/15/2007 12:44:20 PM Hallgeir wrote: [Quoted Text] > 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! 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: Only one user at time can open access file "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/26/2007 6:20:57 PM "Tom Wussernark [MSFT]" <tw[ at ]mic rosoft.com> wrote: [Quoted Text] >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 -- 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/