In Access 2000 and later, you must have exclusive Access to the MDB to save
design changes. No other user must have that MDB open - it doesn't matter
that the other users are not making design changes.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
The solution, as Tina suggests elsewhere in this thread, is to split the
'front end' application MDB from the 'back end' data MDB, so that you canReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
make design changes to a local copy of the application MDB and copy it to
the users' PCs without overwriting data.
"Steve M" wrote in message
> Hi I keep getting the follwing error
> 'You do not have exclusive acess to the database at this time. Your
> design changes will not be saved.'
> I want multi user access to the forms. When this happens no one is in
> design mode. The settings are set to shared - no locks.
> I just cant understand it,
> any ideas??