MS-Access - A Few General Questions

[John Buffum]

We have Access databases on a server. How do I set up the workstations to
access the database on the server over a network?

 

[Beetle]

The application should be split into a Front End and Back End. The BE will
contain the tables and relationships and the FE will contain everything
else (queries, forms, reports, modules). The BE should reside on the
server and each user shoul have their *own* copy of the FE
(preferrably on their local hard drive). Recommend you use UNC path
naming, as opposed to dive letter path naming, for the link to
the BE. You can find more info on Tony Toew's page at;

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

 

[Albert D. Kallal]

We have Access databases on a server. How do I set up the workstations to
access the database on the server over a network?

I explain how this works on a lan here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

and, for a wide area network, you can read the following.

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Reading the above two should get you up to speed for how to use ms-access on
a network in multi-user mode...

 

[pddxxx]

Once you've split your application, we have a free tool to help you
keep each end-user's copy of the application updated. Application
Starter - http://www.peterssoftware.com/aps.htm

Peter De Baets
http://www.peterssoftware.com