DAO and Windows 2003

K

KMac

I have an Access 2002 application that consists of a front-end (.mde) and
three back-end (.mdb) files. (This use to be three different applications,
but I combined the front-ends into one, but left the back-ends). The
application has seen heavy use (multiple-users) over the past 6 months with
no problems until about 2 weeks ago when Windows 2003 was loaded on the
server. Now we are intermittently getting a 'File In Use' error when someone
tries to launch the application. When this occurs, I can open up explorer
and see that there is no .ldb file for the back-end database that it is
trying to connect to, and if you try to open in directly, is says the same
thing... Already in Use. This indicates to me that it is being opened with
exclusive rights, but I know that none of the users even know where these
back-end tables reside so that can't be the case.

The application still use the DAO Ojbect Library... is there a problem
using it with Windows 2003?
 
A

Albert D. Kallal

The dao issue is a non issue here.

It if very possible that users do not have full permissions to that
directory. users need create, delete,a nd full read/write permissions.
Failing to give all 3 to each user means that the locking file can NOT be
created..and this means ms-access has no choice, but to open in single user
mode...

Check your folder permissions ......
 
K

KMac

Thanks for your reply... I am having the IT group check into this, but I can
see that this could very well be the case, and why the problem appears to be
so random in nature... I'll post another reply when I get the results!
 
K

KMac

Results if permissions inquiry

Our IT group informed me that the permissions are administered by group and
that everyone in the group has the same Read/Write/Modify permissions (which
they said included Create/Delete...) I was sure hoping that this was the
case, but I guess I will continue my quest. Thanks for the good info
anyway...
 
Top