Exclusive Access in 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Childs - 30 Sep 2004 00:20 GMT

I have just converted an Access97 application to Access2003

Under Access97 it was possible to change forms e.g. add
buttons, while other users were in the application - this
is now not possible under Acess2003

How does one set up an application in a multi user
environment that enables one to make to changes to forms,
objects etc while other users are in the application??

I note that from information on the Microsoft site, a
strategy is to assign an object to a private copy of the
database and then to export the object back into the main
database. Is this possible under 2003 if users are in the
application or would I have to ensure that no users are in
the application??

Note:
All users have admin rights - do I need to set up the
security on the database so that only I have admin rights??

Reply to this Message

Douglas J. Steele - 30 Sep 2004 02:27 GMT

You can't, but then you shouldn't need to either.

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing just
the tables). Only the back-end should be on the server: each user should
have his/her own copy of the front-end, preferably on his/her hard drive.
You make the changes in your copy, and then distribute a new copy to all
users.

To help in this process, take a look at the free Auto FE Updater Tony Toews
has at http://www.granite.ab.ca/access/autofe.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have just converted an Access97 application to Access2003
>
[quoted text clipped - 16 lines]
> All users have admin rights - do I need to set up the
> security on the database so that only I have admin rights??

Reply to this Message