Database With Multiple Users

[Curtis Stevens]

Simply curious here as one day I may have to face this situation. Right now
it is just me & have an access database. But what about companies with
multiple employees such as 10 or 20. How do they manage a database & allow
all users to access it? Would you convert my access database to SQL, host
the SQL on a server on the network and then have access installed on all the
users computers, which they would use to access the database on the sql
server?

What programs do most small and/or large companies use to have all their
employees interface & interact with their databases; add & update records,
etc?

Thanks!
Curtis

 

[RBear3]

It depends. We have about twenty users and we simply use Access. The
backend (tables) are in an MDE file on the server. Each user has a
front-end mde with forms, queries, and reports and linked tables. The
workgroup file is on the LAN.

This is not the only way, but is one of the simpler methods. If you have
high usage, poor LAN reliability, lots of reads/writes, etc. - you may run
into problems and find that a server works better.