Cannot open <file> file.... error

[Jeanne Clotfelter]

We have been running multiple user split Access 97 apps for many years. All
databases are set as shared -- no problems with configuration. Both front
end and back end dbs are located on the network servers (running as clustered
servers.)

Recently we moved to Active Directory. Since then we are experiencing
security problems. One person will successfully the application. The next
person can open the front end but not the data tables. They get the infamous
'Cannot open <data file> file.....' error.

Here is what we have tried......
1. Get everyone off the system -- close application
<datafile>.ldb does not delete -- and cannot be deleted by sys admin
2. Switch server to other cluster, then delete <datafile>.ldb
3. Repair and compact data mdb
4. Copy front end mdb, then repair and compact.

This will work for a day or so, or in some cases, not at all.

We are running over 20 instances of database applications and so far, at
least 8 of them have experienced the problem -- the ones that are most likely
and ofteb to be accessed by multiple users.

Does anyone have a theory?? Could it be related to Active Directory??

 

[Jeanne Clotfelter]

For clarification, the error is not the 'trusted site' error, but this one.

The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have checked the permissions on the folders and the users all have read
and write access to the folder and the files within it.