Access app for mult users

  • Thread starter Thread starter Len Buchanan
  • Start date Start date
L

Len Buchanan

Is there anything I need to do special if I want to place an Access app
on a server and allow multiple users into the application at the same
time? Any information would be most beneficial.

TIA
Len Buchanan
 
Split the database (documented in Access Help) into a Front-end/Back-end
where the BE(Tables) is on the server, anf the FE (everything else) resides
on each user's desktop.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Is there anything I need to do special
if I want to place an Access app
on a server and allow multiple users into
the application at the same time?
Click to expand...

As Kevin pointed out, one of the first things you want to do is to split the
database into a back-end (tables, data, and relationships) and front-end
(queries, forms, reports, macros, modules, and local lookup tables) and give
_each_ user a copy of the front end. They can use Linked Table Manager to
relink to the shared tables in a visible network folder. They will need full
permissions on that folder: add, update, and delete.

For an overview of multiuser topics I thought worth discussing with my user
group, download the presentation on _Access in a Multiuser Environment_ from
http://appdevissues.tripod.com/downloads.htm.

For more advanced, detailed information on multiuser Access, the best
collection of information and links I know about is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
 
Back
Top