Access 2000 multiple users

[Guest]

Hi
Can anyone tell me how to make my database allow " save" be allowed by
multiple users? At present I am having to take all updates home and reload
the amendements individually.
Thanks

 

[Joseph Meehan]

Hi
Can anyone tell me how to make my database allow " save" be allowed by
multiple users? At present I am having to take all updates home and
reload the amendements individually.
Thanks

Do the users access the database via a LAN? if so Access is multi-user,
but should be "Split" into a front and and back end.

If you do not have a LAN and they are using it on individual machines,
then search the Access help file for "replication" That will give you the
basics.

If you have additional questions please let us know.

 

[Guest]

Hi Joseph

database is on a LAN, but when trying to save design changes to forms, or
update some tables ... error message " You do not have exclusive access"
appears.

 

[Guest]

Sorry .. I should have been more specific ... I dont know what you mean by
froint and back end....

 

[Guest]

You can split a database so all of the data etc is kept on the file on the
network, and just the basic interface is given to your users.

 

[Van T. Dinh]

Basically, this means that you divide the database application to 2 MDB /
MDE files called Front-End and Back-End due to their usage. The Back-End
contains only Tables (ie. shared data) and should reside on a network drive
/ directory that database users have Read / Write permissions. The
Front-End contains the user interface elements ( Forms / Reports ) as well
as other support objects like Queries / Macros / Modules. The Tables from
the Back-End are linked to the Front-End
so that the user of the Front-End can access the data. Each user should
have his own copy of the Front-End on his PC.

This way, each user (including you) has exclusive use of his Front-End. You
can then modify your Front-End independently and when you are ready with the
new Front-End, you can distribute the new Front-End to each use.

See Access Help on "Splitting a Database" and Tony Toews' article:

http://www.granite.ab.ca/access/splitapp/index.htm

 

[Joseph Meehan]

Hi Joseph

database is on a LAN, but when trying to save design changes to
forms, or update some tables ... error message " You do not have
exclusive access" appears.

You can not make design changes while anyone else has the file open.
Access allows you to open a file exclusively (see "File" " Open" and look
around in the box). You can not do this if others have it open at the time
however. It will keep all others out of the file until you quit.

A not too unusual problem related to this is when someone shuts off
their computer without closing Access. It leaves the YOURFILENAME.ldb file
still there. You need to delete that file manually if that happens.