Prevent linked table from locking records

[aaronlglover]

Hey All,

I have been searching all over the web trying to find a solution to my problem.

I have a FE and two BE access database. One BE is used to house the table that is modified by the user and one BE that is to be used for reference only. My problem is this, when I link tables from the reference only BE and the FE is open it makes the reference only BE read only why I try to exclusively open it.

I have changed the security on the reference BE so that "Everyone" only has "Read" permissions...that doesnt fix it.

The reference only BE is an accdb so I do not believe that user level security is an option. I need to be able to exclusively open the reference DB without having everyone log out of the FE.

Anyone have any thoughts?

Thanks

 

[lameid]

I have not used an ACCDB / Access 2007 but assuming the same principles apply, you can't. Technically when you access a Backend through a link, you open the file... So that will prevent an exclusive lock. If everyone closes things that use the table, then you should be able to get exclusive access.

What is it that you are doing that you need exclusive access anyways?