Question Share Access Database

[Marlena]

Hi there,
I'm using access 2003, What do I need to do to share access database with other users?
Thank you.

 

[Dlovan-IT]

hi Marlena for share your database , the first thing you need to connection between each computer after that in the other user create new database in the external database tab choose access and link the table in the basic machine after that whet ever you want you can do it

 

[gemma-the-husky]

officially - nothing. it is automatically multi-user. (Unlike excel where you get "another user opened this ... do you want this to be read-only")

however, unofficially - the problem is that is generally ill-advised for multiple users to open the same physical copy of a database.

therefore the perceived wisdom is to SPLIT the database. put the tables in a BACKEND database, and the forms and code in a FRONTEND database, and link the frontend to the backend

Now each user needs a separate copy of the FRONTEND.

The other advantage of splitting databases is that you can amend the design of your forms etc, independently of other users - which is hard to do in an unsplit database.