Shared database problem

#1 (**permalink**) 29-Oct-2005, 12:35 PM

Hi I keep getting the follwing error
'You do not have exclusive acess to the database at this time. Your design
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6147-shared-database-problem.html
changes will not be saved.'
I want multi user access to the forms. When this happens no one is in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
design mode. The settings are set to shared - no locks.

I just cant understand it,

any ideas??

baz

*

#2 (**permalink**) 29-Oct-2005, 12:35 PM

is your database split? that is, backend (tables only) on the server, and a
copy of the frontend (all objects except tables) on each user's PC. if not,
recommend you split it - multiple users in a monolithic database is just
begging for database corruption.

hth

"Steve M" wrote in message
news:egjahfC3FHA.3900@TK2MSFTNGP12.phx.gbl...
> Hi I keep getting the follwing error
> 'You do not have exclusive acess to the database at this time. Your
design
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
> 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??
>
> baz
>
>
>

#3 (**permalink**) 31-Oct-2005, 11:19 AM

For multi user access to a single mdb file, MSAccess creates a seperate
file with the extension "ldb". If you don't have sufficient file system
privileges to create or access that ldb-file, it might be a problem.

You might also want to check if there is an old ldb-file which cannot be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
deleted or updated by MSAccess. Try to delete it manually, but make
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
sure that everybody closes the database first.

Steve M wrote:
> 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??
>
> baz
>
>
>

#4 (**permalink**) 31-Oct-2005, 11:19 AM

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 can
Reference:: 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.

--
Brendan Reynolds

"Steve M" wrote in message
news:egjahfC3FHA.3900@TK2MSFTNGP12.phx.gbl...
> 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??
>
> baz
>
>
>

#5 (**permalink**) 01-Nov-2005, 13:40 PM

"Roland" ??????:e%23R15HT3FHA.3876@TK2MSFTNGP09.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
>
> For multi user access to a single mdb file, MSAccess creates a seperate
> file with the extension "ldb". If you don't have sufficient file system
> privileges to create or access that ldb-file, it might be a problem.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6147
>
> You might also want to check if there is an old ldb-file which cannot be
> deleted or updated by MSAccess. Try to delete it manually, but make
> sure that everybody closes the database first.
>
> Steve M wrote:
>> 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??
>>
>> baz
>>
>>
>>