Microsoft Jet Database Engine Error

[Chris]

Hi-

I have admin privileges to the database, I am the Admin.
Whenever I make an attempt to do any updates I receive
this error:
"You do not have exclusive access at this time. If you
proceed to make changes, you may not be able to save them
later."
Take note that noone is logged into the database but
myself. What could possibly be the issue? I have
verified my security rights and privileges. I have full
admin rights to all of the tables, queries, forms, macros
and the database itself. Could an import of the database
have caused the security to be invalid? If there is any
information that you could pass, please do so.

Thanking you in advance!

 

[Lynn Trapp]

Obviously you are using Access 2000 or later. What you are experiencing is a
BY DESIGN feature. Since Access 2000, you must have exclusive access to the
database to make any changes to the forms or reports. In your case, since
you say no one else is logged in, that suggests that there is a "ghost"
user. Exit the database and check to make certain that there is no .ldb file
in the same folder that your database is stored in. If the .ldb file is
still there, delete it and try again.

 

[chris]

Hi Lynn-

I do not have any .ldb files stored in the same folder
that my database is located. When I open the production
database to open as an exclusive user only, it says
that, "you do not have the necessary permissions to use
the database. Have your system administrator or the person
that created this object to establish the appropriate
permissions for you. I am the system administrator, but
not the owner of the DB and I have assigned myself all
rights and privileges to the database, tables, reports,
macros and queries. But When I open the shortcut to the
database to open as an exclusive user is says, "you cannot
open the database for exclusive use because another user
has the database open or because you do not have
permissions to open exclusively. I verify who is in the
database, which is, a user with data entry permissions.
I am so confused!

Thank you for you help so far. Also, I apologize for
sending this email to you directly. When I click on reply
(E-mail) it does not do anything.

 

[Lynn Trapp]

Answers inline below

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hi Lynn-

I do not have any .ldb files stored in the same folder
that my database is located. When I open the production
database to open as an exclusive user only, it says
that, "you do not have the necessary permissions to use
the database. Have your system administrator or the person
that created this object to establish the appropriate
permissions for you. I am the system administrator, but
not the owner of the DB and I have assigned myself all
rights and privileges to the database, tables, reports,
macros and queries.

When you open the database are you prompted for a username and password?

But When I open the shortcut to the
database to open as an exclusive user is says, "you cannot
open the database for exclusive use because another user
has the database open or because you do not have
permissions to open exclusively. I verify who is in the
database, which is, a user with data entry permissions.
I am so confused!

I thought you said that no one else was logged in to the database. How are
you determining that a user with data entry permissions is logged in?

 

[chris]

Lynn-
I'm sorry you are correct, there is an .ldb file, but i
cannot delete it. The very first time I sent this email,
noone was logged in. I was determining who was logged in
by looking at this Secured file(Access.LockFile.9). This
database is a mess. It has been passed to me to fix, but
I haven't a clue on where to begin.

 

[Lynn Trapp]

You may have to get your network administrator to delete the .ldb file for
you.