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!
> 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/