You do not have exclusive access ERROR

[Guest]

I am having the same trouble that I see many others have had:

“You do not have exclusive access to the database at this time. Your design changes will not be saved.â€

This ERROR will not leave me alone! Can anyone help me??

I am the only one who works in Design Mode on this database, so I don’t make changes when others try to use it. (They only enter and update data in forms and run the occasional report.)

Because of our network, no one is able to save anything on the hard drives – so splitting the database will not really make anything quicker.

I have tried changing the settings to “Advanced†setting to†Shared†and “No Locksâ€.

I have given full permissions to my group of users for the file and the folder because of the “Access.LockFile.9â€.

I have checked that the “Record Locks†property in the forms and reports are set to “No Locksâ€.

Still, I get this error message. Can anyone help me keep my sanity???? PLEASE!!

(e-mail address removed)
or
(e-mail address removed)

 

[Douglas J. Steele]

It doesn't matter if you're the only one in Design Mode or not: you must be
the only user period.

Splitting the database always makes sense. If they can't save the front-end
to their hard drive, you're still miles ahead if each user has his/her own
copy of the front-end on the server. Not only will that solve your current
problem, but it also significantly reduces the likelihood of database
corruption.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am having the same trouble that I see many others have had:

"You do not have exclusive access to the database at this time. Your

design changes will not be saved."

This ERROR will not leave me alone! Can anyone help me??

I am the only one who works in Design Mode on this database, so I don't

make changes when others try to use it. (They only enter and update data in
forms and run the occasional report.)

Because of our network, no one is able to save anything on the hard

drives - so splitting the database will not really make anything quicker.

I have tried changing the settings to "Advanced" setting to" Shared" and "No Locks".

I have given full permissions to my group of users for the file and the

folder because of the "Access.LockFile.9".