Locked linked table (1 Viewer)

Dear readers

I have a database A with 2 tables. 1 OPTIONS and 1 datatable.
Users are allowed to change data in datatable, but not OPTIONS.
OPTIONS is used in all forms.

Idea was to have OPTIONS more secure
I thought to create database B with table OPTIONS.
Table A has a linked table to options in B
Database B is located in a directory with only limited amount of peaple having ReadWrite credentials. All the others have only read.

This goes OK if a user uses A. But when a ReadWrite user uses A, it creates a B.laccdb at B and then the other users are locked out and get the message that B cannot be accessed.
Is this construction doomed to fail due to this?
Are there other possibilities which might work?

Many thanks

Ben

Ben,

How is the table OPTIONS accessed in all the forms? Is it the datasource of every form? If so, you may want to make sure that the Recordset Type is set to Snapshot. If you are accessing the data within the OPTIONS table via a recordset, make sure the recordset type is set to dbOpenSnapshot.

I have to admit it's not a scenario that I've experienced before, if the above doesn't work I don't know what the answer is

Thanks Alfisdad,

I will try this. Thanks for your suggestion

Ben