Access on network

pherm1

New member
Local time
Today, 17:10
Joined
Feb 15, 2007
Messages
4
Is it possible to have an access database on a central server and multiple users using it at the same time. Do I need to set up any special properties? Thanking you in anticipation
 
You can simply put the .mdb file on the server and have everyone run it from there. But a better way to do it is to have one .mdb file have the tables on the server, this would be called the 'backend', and have another .mdb with all the forms, reports, queries, etc, that links to the backend, this would be the 'frontend', saved on each workstation.

Hope this makes sense, it's really quite simple... :):)
 
All you need to do is to make sure that the users accessing the server have the right user rights and then you can share the access database. I would recomend that you only have the back end with the data tables on the server, then on each pc have the main user interface installed, this is easy to setup, if you need any help yell out and i will help were i can.
 
It would also help a great deal if you put any tables that get used for populating combo boxes etc in the front end if the data doesnt change.

For example, we have to record a clients weight. We work here in Stones and Pounds, but I found it hard to record that weight in access. So I made a table up that has a weightID (pk) then stone and pounds. So a user selects the stones and pounds, but it stores the record as the primary key ID.

This doesnt get changed, so it can sit in the front end so it doesnt have to pull data over the network each time a user enters a weight and help speed this up.
 
Thanks everyone. Tried it today without splitting it no problems. May try splitting the database.
 

Users who are viewing this thread

Back
Top Bottom