Locking behaviour

I have an access application with a split FE (forms) and BE (tables). There are also several read-only data access pages using the BE as a data source.

Most users only view the data via the data access pages. These users have read-only access to the database files and the directory containing them. A few users manupulate the data using the FE database and the forms.

My problem is that, when a "power user" opens the database directly (either the FE or BE), the data access pages become unuseable for the "normal users". They cannot bind to the database due to an exclusive lock. I have both databases set to shared mode. The messages that the users get are:

Data provider could not be initialized.

Could not use "; file already in use

Does anyone know how I can get around this problem so that the data access pages are "always available"?

TIA

How is you FE DB linked of the BE Db?

S-

Via linked tables in Access. I actually started with one database and then used the "split" utility to break it apart.

Are you using bound or Unbounded forms in you FE. If there are bounded forms, that may be causing you problem, becuase as you are looking at the data in the recordset, it locks those records


S-

I was finally able to solve my problem. It turns out that ALL users must be able to read and write the .ldb file. If not, then the database is opened in exclusive mode. This means everyone must have read/write access to the directory containing the database. I changed the permissions on the directory but set the .mbd files to be read only and everything seems to work as I had hoped.