file locking over a network 1

[aardvark92]

I'm not sure if this is the best place for this question. We've run into an unusual situation here.

We have several users running Access 97. The database files are stored on a network drive so they can be accessed by whoever needs them.

Recently, several databases have begun locking up during processing. I have found that the problem is consistently happening during delete queries. The error message is Couldn't update; currently locked. This is happening even when only one person is using the database.

We have been able to get around the problem by copying the database files to the c: drive. When run from c: everything works without problems. But then the files are not available to other users.

Has anyone experienced anything like this before? What would cause the files to lock only when run over the network?

 

[Trendsetter]

When records are locked in Access it does not apply to a single record but to a "Page" and all of the related tables and records that are linked by referential integrity.
Are the records being copied to C: still linked via relationships???

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[Terpsfan]

Is this by chance happening on a Novell server? If so you need to increase the number of record locks on the server.

 

[aardvark92]

Thanks for the replies. It is a Novell network; I'll talk to the network administrator about increasing the number of record locks on the server.

Thanks again for the help!