G
Guest
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??
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??