Exclusive Use?

[screach]

All:

I have a database that we have installed accross our network. We are a Windows 2k network with Office2k installed on all machines.

The error I am getting is random (only on certain machines)

"You attempted to open a database that is already opened exclusively by user 'Admin' on 'Intern1'

however no one is using the database. Any ideas?? I know with SQL you can view who is in a database and then kick them out (sometimes get ghosted accounts that need to be removed to free up licenses etc....) wondered if Access has a similar utility?

Screach.....the sound of your world coming to an end at the sight of the dreaded BSOD!

 

[hymn]

There are various things that could be wrong
The machine that the DB is opened on is set to exclusive
is normally the main reason
if you do a search on this you will prob. find a few different explanations for various reasons

Hope this helps
Hymn

 

[JoyInOK]

If you have VBA code behind your forms, you may have an invisible instance of Access running because you forgot to release the variable. If you have something like this:

dim dbMine as database
set dbMine = currentdb


Make sure you release the variable like this:

set dbMine = nothing