Exclusive Mode

[Guest]

We use Access 2003 on XP Prof in a multi user environment. I understand that
the database has to be in exlusive mode to perform certain administrative
functions such as compacting & repairing or backing up the database.
Every now and again (like today), when I try to compact & repair the
database, i get an error message: "You attempted to open a database that is
already opened exclusively by User 'Admin' on machine 'xxx'. Try again when
the database is available."
Machine 'xxx' is my machine and I am the only one in the database. I have
checked to see if multiple occurrences of the database files opened, which
there are none. I have logged on/off the machine, restarted and rebooted
with no change.
I would appreciate any thoughts/guidance you may have as to where to look
to close occurrences of the database. Thank you!

 

[Guest]

Your case is very rare. When that happens to me, the first thing I do is run
the Task Manager to see if there are any lingering copies of Access running.
Usually after a reboot, that should solve the problem.

All I can think of is this: are there any functions that run in an AutoExec
macro that may open recordsets?

Try opening Access alone, then going into the Tools menu -->Database
utilities-->Compact database. This will ask for a database file, rather than
first opening the database, then compacting it.

Did you compile the code before compacting? Sometimes that helps. Try also
using the /decompile parameter to decompile, then recompile your code. When
that's done, try compacting it.

The worst case is that this is a corrupt file.

Ray

 

[Bill Mosca, MS Access MVP]

Close out Access. Reboot again. Then, open Explorer and find the file. If
there is an LDB file in the folder with the same name as the MDB file,
delete the LDB file. Then try your compacting.

LDB files should be destroyed when the database is closed, but sometimes
they are not. Since they control locks, they can "think" another instance of
the file is open when it is not.

 

[Guest]

Teri - you state you are using machine xxx but you don't definitely state
that you are the Admin of the machine. you may be assuming that you
are...but with xp one can use the computer as a user and not be the admin.
this is definitely something to double check

 

[Guest]

Thank you! It finally let me in at the end of the day, but I am keeping this
for future reference as this was not the first time it happened. I really
appreciate the assistance.

 

[Guest]

Good point! I am admin of the machine as well as a network admin.

 

[Bill Mosca, MS Access MVP]

It still sounds like a hanging LDB file to me. You might want to look for
one the next time it happens.

 

[dbahooker]

this kinda crap happens to me ALL THE TIME

that is why I swear at MDB dipshits.. MDB isn't stable enough; reliable
enough for a single user and a single record.

Use Access Data Projects and your troubles will dissapear

-Aaron