Share drive problem

[OracleVictim]

I have an Access database on a share drive that is set to multi-user, no locks.... I'm using folder security to control access to it. All authenticated users have read access and about 4 folks have read/write to this folder... The database itself is Access 2003 in a 2000 format. Until recently all of my users were on Windows 2000. And all worked well. Now they are in the process of upgrading to Windows XP....

The problem is that whenever anyone with write privs to the folder opens the app, other XP users are locked out (but anyone with Windows 2000 can get in)... But oddly enough they don't get an error.... They double click on the app and nothing at all happens.... However, it appears that multipe "read only" users can access the app simultaneously.

I've tried splitting the app into client server (no luck), I've converted the database to 2002-2003 format...(no luck), and I have tried giving all authenticated users write privs to the folder (no luck). Oh, lastly, I simply created a default database and tossed it into the share folder to see if it acted the same as my bad application (it did..... So I'm convinced that the application itself is fine).

Any ideas?

Thank you in advance.

 

[Remou]

This is due, as far as I know, to Access creating a lock file (.ldb). The usual rule is that all users should have read/write permissions for the Access directory.

 

[Remou]

There is a very recent thread on this topic:

thread181-1392702

 

[OracleVictim]

Thanks....

This happens when 2 XP users with write privs access the database... I also tried giving write privs on the folder to all authenticated users.. (no luck)...

 

[Remou]

This is not an Access issue, it is a Windows issue. You will find several Windows forums in Tek-Tips.