Question Access 2010 multuser: db/record locking issues

[Timtropolis]

Greetings all,

I've developed a split db (A2010) that has a FE installed on local machines(7 users in all) and the BE up on the network.

The issue I'm having is that if one person opens the front end on their machine and they open up a report, or a table (which I have setup using a datasheet form with read-only rights), then they have complete control of the BE database, preventing anyone else from updating ANY table in the back end. If I go into a table that is not the one being viewed or used in a report and try to update, it won't allow it.

If I try to run my import process and run a DELETE statement from VBA, I get the following error message:

3086: Could not delete from specified tables.

I have checked my advanced settings and they are as follows:

Default Open Mode: Shared
Default Record Locking: No Locks
Open databases by using record level locking: Unchecked

I have tried changing these settings, specifically the last one as its global, but I still have this problem. Also, I've checked with IT and there are no restrictions on the folder in which I have the BE located. I've set many databases up like this in the past and have not ever had this problem but this is the first one I've done using A2010.

Is there another setting or something I'm missing here?

TIA,
Tim

 

[arnelgp]

use queries (possibly a snapshot copy) on your form and reports.

 

[Timtropolis]

Hi arnelgp,

Tried that but that did not help.

 

[arnelgp]

have you checked the settings of each FE and also the BE if they are all Shared/No locks.

 

[Timtropolis]

Yes I have, as I stated in my original post I have set these accordingly and experimented with different settings but to no avail.

 

[arnelgp]

experiment again, i dont know what causing this.
instead of setting the whole report/form read-only, you can also set each controls Locked property to True.

 

[Timtropolis]

Yeah, like I said this is a very odd thing.
The problem is I'm using snapshots for both the datasheet views and for the report views, so not sure why that would lockdown the database tables.

Thanks for you help though, very much appreciated.

 

[Timtropolis]

Follow up question: Does the owner of the object (in this case, tables) have any bearing on a multi-user database? Also, do the permissions for the database file itself (these would be accessed when right clicking the .accdb file and then selecting Security, Advanced) have any bearing the problem I'm having?

Thanks,
Tim