Multiple users of Acess2000 database?

  • Thread starter Johan Myrberger
  • Start date
J

Johan Myrberger

Hi,

what options are available to make an Access2000 database available for
multiple users? Ultimately I's like to assign different rights (read,
update etc) for various users, per table in the database. However I'd be
happy for means of providing full access to all users, but avoiding
conflicts when updates are made.

Solutions using Access2000 by ev. share the file on the LAN, migrating
the database to another tool or using some kind of web based interface
are potentially of interest.

Any pointers to information on this topic?

Best regards
/Johan Myrberger
 
F

Fred Boer

Dear Johan:

Good news! Access is multi-user right out of the box! :)

Please be sure to split your database; don't make the mistake of letting
multiple users access a single MDB file. Splitting the database creates a
"back-end" MDB containing only the data tables, and "front-end" MDB(s) with
the queries, forms, and reports. Look up on it in Access help and/or here:

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

Assigning different rights and permissions can be done by applying Access
security.

HTH
Fred Boer
 
L

Lynn Trapp

versatile protection and control. However a simple mistake can lock
everyone including God out.
Click to expand...


Actually, God doesn't get locked out, as long as He has the right .mdw
file.... :)
 
Top