How to share Access

[karinos]

I have created database and i would like to share it with multiple users and also i want them to make changes and update it as they go. My questions is:
how do i do that?
Can this be done?
Can several users be on the database at the sametime and make changes?

Pls. help..and also if you can tell me a link where i can find more info about this.. i would really appreciate. Thanks.

 

[Malcy]

Two things spring to mind. Firstly licensing and secondly version control.
For people to use the database and make changes they need a licenced copy of MS Access. If just data changes I think run time version would be adequate.
Secondly you are likely to have a disaster on your hands unless you very carefully manage version control and testing - in other words if two people make different changes to their copy and then update the master copy sequentially (i.e. copy their file back to the master location) then any changes the first person to copy makes will be lost.
If it is just data updates, rather than programme changes then you need to split back end and front end (do a search) and put the backend centrally and give everyone a front end.
Use the search facility here to research front end / back end / network/ multiple user etc.
Good luck

 

[boblarson]

Check out this post of mine as well:
http://www.access-programmers.co.uk/forums/showpost.php?p=660591&postcount=11