"Access" problem

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
 
J

Joan Wild

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.
 
G

Guest

-----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
.
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
 
M

M.L. Sco Scofield

P.S.
MICROSOFT BLOWS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top