we have several fe_ databases, linked to tables in a shared be_ database.
How can just one of the fe_ database users have exclusive access to the be_ database tables, so that user can make "bulk" changes to the table data. That is, so that no other user can access these tables whilst the bulk updates are happening.
This article goes close, but my attempt to open the be_ (shown below) made no difference, as other users could still open their fe_ database edit the tables...which is exactly what I don't want.
(I put the code in a module of the fe_ that is to have the exclusive access)
Dim WS As Workspace
Dim DB As Database
Set WS = DBEngine(0)
Set DB = WS.OpenDatabase("G:\PropMan\RIdata\RI_be.accdb", True, True)
Any help greatly appreciated.