Sharing Access 2000 file in XP OS

S

Sriram

I have an access 2000 file in XP OS. I open the file in non exclusive mode
and try to open the same file from another computer, it gives me Unable to
lock error.

I was able to do this from win 200. I compacted and repaired the file still
doesn't help.
 
J

John Vinson

I have an access 2000 file in XP OS. I open the file in non exclusive mode
and try to open the same file from another computer, it gives me Unable to
lock error.

I was able to do this from win 200. I compacted and repaired the file still
doesn't help.
Click to expand...

Make sure that you have full (read, write, create, delete) access on
the folder containing the database file. Access must be able to
create, edit, and then delete the .ldb lock file for the database.

John W. Vinson[MVP]
 
S

Sriram

John,

The folder has the full permission. When the file is opened by the first
person, that person has all the access, but when the second person try to
open that's when It's not opening in read write mode.

Also in Win 2000 when an access file is opened directly or indirectly
through another access file which has linked tables, an .ldb file is created.
But strangely with XP the .ldb is not created when an access file is opened
indirectly.
 
J

John Vinson

The folder has the full permission. When the file is opened by the first
person, that person has all the access, but when the second person try to
open that's when It's not opening in read write mode.
Click to expand...

Check to make sure that the database isn't defaulting to exclusive
open (in Tools... Options).

John W. Vinson[MVP]
 
Top