How to use Database on Network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
My database is in central location on the network and I wana share an Access
database amoung my users. how do I do that and at a time how many users can
access the database.
 
Saadi said:
hi,
My database is in central location on the network and I wana share an Access
database amoung my users. how do I do that and at a time how many users can
access the database.
Click to expand...

According to specifications, 255 simultaneous users can share an Access/Jet
database. In actual practice, it is usually far less than that. Most good
develpers take 20 users as a good number. I have over 50 users on one of my
database back-ends without any problems.

To share your database, you MUST split it into a front-end which will run on
each workstation, connected to a back-end running on a file server; even
with only 1 user. Any other configuration is an invitation to corruption.

Splitting is easy. In fact, there's a wizard to help you. Look on the menu
for: Tools ... Database Utilities ... Database Splitter
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top