Exclusive

[Matt]

Is there any way to add fields to the back end while someone else has it
open? I keep running into the problem of having to have everyone else close
the database when I need to edit or add anything into the back end. I've
tried just making a copy of the BE and making the changes, then replacing it
with the new one, but as is typical, other users seem to not comprehend the
idea of not making changes for five minutes.

 

[BruceM]

Users cannot be counted on to cooperate with such efforts. The only
reliable option is to give them no options. This may help:
http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

 

[Peter Hibbs]

Matt,

An easier way to make back-end changes is to do it automatically from
the front-end file. Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'
which will do that for you. Obviously you still need to make sure that
a user is not using a table that the code is modifying but that should
be easier because the BE update code will do that immediately when the
first user runs your database after you have supplied a new front-end.
The documentation explains it all in detail.

HTH

Peter Hibbs.