Database With Multiple Users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curtis Stevens - 10 May 2007 18:00 GMT

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

Reply to this Message

RBear3 - 10 May 2007 18:32 GMT

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.

Signature

Hope that helps!

RBear3
.

> Simply curious here as one day I may have to face this situation. Right
> now
[quoted text clipped - 13 lines]
> Thanks!
> Curtis

Reply to this Message