R
Release Exclusive Lock
I'm using Access 2000 and recently got this message when I try open in Forms
the vbscript (to make changes):
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later"
In details it gives me this:
When attempting to open a database object in Design view, you may encounter
this error message. This occurs because Access requires an exclusive lock to
the database for some object types since other users may attempt to use the
objects. If you change the name of a table, or its definition of fields while
someone has the table open, this will result in a serious error for the other
user. Therefore, you must acquire sole access to the database while you
attempt to update the object. When you release control of the object, other
users will be allowed to use the database (release your exclusive lock).
-I am unable to make any changes (in the past was never an issue).
I'm the administrator of this program.
What is interesting I have several backupsof this Access program, and older
versions (my June 09 backup) I do not get this error. All the security
options are identical between my backup and the one I'm currently using (i.e.
Tools, Security, Workgroup Administrator, and User Group options). -I checked
each tab and box and nothing is different....
Help and suggetions!
Yvonne
the vbscript (to make changes):
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later"
In details it gives me this:
When attempting to open a database object in Design view, you may encounter
this error message. This occurs because Access requires an exclusive lock to
the database for some object types since other users may attempt to use the
objects. If you change the name of a table, or its definition of fields while
someone has the table open, this will result in a serious error for the other
user. Therefore, you must acquire sole access to the database while you
attempt to update the object. When you release control of the object, other
users will be allowed to use the database (release your exclusive lock).
-I am unable to make any changes (in the past was never an issue).
I'm the administrator of this program.
What is interesting I have several backupsof this Access program, and older
versions (my June 09 backup) I do not get this error. All the security
options are identical between my backup and the one I'm currently using (i.e.
Tools, Security, Workgroup Administrator, and User Group options). -I checked
each tab and box and nothing is different....
Help and suggetions!
Yvonne