Network application

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

I just need a suggestion or any point of view...

What is the best way to use an Access application in a network environment?

Should I copy the application made with access on each workstation a link
table to the server? (50 workstation)

Or install the application on the serveur and creat shortcuts?

Thanks

JS
 
Definitely each user should have their own copy of the application,
preferably on their hard drive (as opposed to on the server). You're
increasing the risk of database corruption significantly if everyone's
sharing the same copy.

As an aside, you might want to take a look at what Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm That'll give you an easy way to
ensure that each user has the most up-to-date version of the front-end in
case you need to make changes.
 
The best way is to usually split the database into a
backend (all the tables), and the front end (all queries,
reports, forms, code).

The backend database resides on a file share on a server.
Each client has a copy of the front end file, which looks
to the backend for the data.

There are many good reasons for this. The best two are it
is easier to backup just the database. There is no reason
to do a frequent backup of the forms/reports as they don't
change often.

When you need to make changes, you can send out a new
front end to each user, and they don't need to worry about
overwriting their existing data.


Chris Nebinger
 
Back
Top