Exclusive access error

[Ted]

Hi all, my company has recently upgraded to Access 2000 from Access 97. I
know its a little late but better late than never. My question is whenever I
try to make a change to the database I get the following error...

"You do not have exlusive access to the database. Your design changes cannot
be saved at this time. Do you want to close without saving your changes?"

In Access 97 I could make changes to forms and reports in the live database
with users in it. Is this a change to Access that is going to stop me from
making changes to the live database if others are in it. I don't make major
changes but if I want to change the alignment of a field in a report it
won't let me.

TIA
Ted

 

[Allen Browne]

Yes, Ted. You are not going to be able to modify the mdb in Access 2000
while others are using it.

This is due to the way Access 2000 performs a monolithic save.

You can read about this change (and others in this article:
Converting from Access 974
at:
http://allenbrowne.com/ser-48.html#usability

In reality, modifying an A97 database while others used it was not a great
idea anyway. If you are serious about using the database reliably with
multiple users, consider splitting it so each user has their own copy of the
front end. Being able to continue your development unimpeded is only one
benefit. If that's a new concept, see:
http://allenbrowne.com/ser-01.html

 

[Ted]

Thank you Allen. That's what i kind of figured. I looked over your website.
I'll be going there a lot more!

Question and I think I already know the answer to this but if I split the
database and keep the front end on each user's machine locally...how do I
update the front end application on all of the desktops easily? Any tips? I
have around 60 desktops that would need their front end to be updated if I
split the database.

 

[Douglas J. Steele]

Take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm