Sharing a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sycosyxx - 11 Aug 2006 13:09 GMT

Ok in a nutshell here is my problem and I havn't worked with access since 97
so I need some help. I need to create a database that I can share amongst
users with all having full access to modify, edit, and delete records. I need
to be able to share this with all the users on our small office nework and we
don't have the funds to aford sql server. Is there anyway to do this?

Reply to this Message

Joan Wild - 11 Aug 2006 16:03 GMT

Access is multiuser out of the box.

Split the mdb into frontend/backend. The backend is put on a server in a
folder where all users have read/write/create/delete permissions. A copy of
the frontend is put on each user's PC. It will contain linked tables,
linked to the backend on the server. There is a database splitter in Tools,
Database Utilities to do this for you.

The splitter will split the file (you'll have to copy the FE to each user).

Signature

Joan Wild
Microsoft Access MVP

> Ok in a nutshell here is my problem and I havn't worked with access
> since 97 so I need some help. I need to create a database that I can
> share amongst users with all having full access to modify, edit, and
> delete records. I need to be able to share this with all the users on
> our small office nework and we don't have the funds to aford sql
> server. Is there anyway to do this?

Reply to this Message