Multiple users at once

[acrowe97]

Is there a way to allow multiple people to use, update and save an Access database similar to collaborating using Google Drive? I've heard of splitting the database but I'm not entirely sure if that's the method to use. I've also heard of SharePoint but I don't know if that's the solution either. My boss is annoyed that co workers will have to wait until someone else is done to use it. Also, if I split, will it be difficult to create/edit things ex. create a new table or edit/add forms and reports?

[orange]

See this community link for more info on multiuser Access database.
Good luck.

[acrowe97]

Thank you!

[CJ_London]

Also, if I split,

there is no if. If it is multi user it must be split. Your boss will be even more annoyed if one day, no one can get in and you have lost everything because the file has become corrupted. Personally even if it is single user I would split it. Users don't share excel or word - they each have their own copy of the 'front end' in terms of the application. Access is a tool that enables you to create applications and provides an environment in which to run them. An excel/word user opens files as a back end - but even on google drive they are not truly shared, only one user (the first to open the file) can save changes to the original file. everyone else can only save copies. Access is a tool that enables you to create applications

Orange has provided some good links - do read them

[acrowe97]

I'm now having an issue with editing relationships. I have to add a relationship between a new table and an old one, but referential integrity check boxes are grayed out. Is this because of the split?

[acrowe97]

Nevermind, problem solved.