How to Deploy?

radink

Registered User.
Local time
Today, 11:30
Joined
Dec 21, 2006
Messages
18
Well, I've got my DB ready to go. Now what?

I need to host it on our Win2003 server. How do clients use it?

I think im getting more confused as I try to figure this out. We are a small company and I just want to be able to have everyone here use the database at the same time without too much fuss. Do I just have to have access on each machine and let them open it from the server, or is there more to it than that? I just don't want them to be able to get into the DB itself and modify things, just add entries and pull up reports.

Thanks!
 
Last edited:
If you don't want all and sundry messing around with your database, you will have to add security.
For an excellent overview of Access security, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know.

When using Access on a network, you have the "front end" and the "back end". Basically the back end goes on the server and contains the tables. Evertything else (queries, macros, reports etc.) is the front end which is installed on each computer. Remember, if you make any changes to the database (except the tables) you have to change the front end on every work station.

You must first split the database into front end and back end. Do a search on "network" on this forum, you should get all the info you need.

You do not require the full version of Access on each computer. The "runtime" version is all thats required to run the database. The only full version of Access should be the one on your computer if you make yourself the database Administrator.

Good luck
 

Users who are viewing this thread

Back
Top Bottom