"Access" problem

  • Thread starter Thread starter rekoop
  • Start date Start date
R

rekoop

Hello,
I have a client who has created a database that is
accessible on a common drive. They have just encountered
the error message below. The message appears even when
the database has been copied to a local drive with local
access only. Any ideas on the cause and possible
solutions? Sorry for this but my Access knowledge is
limited.

Error Message...
You do not have exclusive access to this database at this
time. If you proceed to make changes you may not be able
to save them later.

Thank-you
 
Have them open Access, then go to File Open. In the dialog select the mdb,
and then in the lower right click the dropdown beside Open, and choose Open
Exclusive.
 
-----Original Message-----
Hello,
I have a client who has created a database that is
accessible on a common drive. They have just encountered
the error message below. The message appears even when
the database has been copied to a local drive with local
access only. Any ideas on the cause and possible
solutions? Sorry for this but my Access knowledge is
limited.

Error Message...
You do not have exclusive access to this database at this
time. If you proceed to make changes you may not be able
to save them later.

Thank-you
.
Click to expand...
Are they trying to modify the design of any objects?

There are several possibilities. 1. Whoever created the
database set up record locks for the forms and objects.
If you plan on having multiple users you will need to
change this. 2.Sometimes Microsoft Access, like
everything Microsoft, is just plain buggy. Check the .IDB
file (should be in the same folder as the .mdb file with
the same name) open it with notepade, it should tell you
what machine is causing the problem.
P.S.
MICROSOFT BLOWS
 
P.S.
MICROSOFT BLOWS
Click to expand...

Well gutless. If you weren't "anonymous" and gave some facts to back up you
allegations, maybe someone would listen.

Feel free to stop using Access and everything Microsoft.

Ever hear of Unix, Linux, Oracle, DB2,??? I hear all of these products are
totally bug free. Maybe you'd be happy using them?

Sco
 
Back
Top