Sharing an Access Database

[alexc333]

Hi All,

I have a database that I would like to share with someone else online, as we both update it regularly.

I'm not sure what my option are on this.

Does skydrive allow this?



Or what about any option in Office 2010? It seems to have more online options.

Whatever is the simplest solution as I don't know much about computers and this is already driving me mad

Any help would be so appreciated!

[Stingaway]

If you don't know much about computers, "Sharing an Access Database" is not the best place to start...

I don't know if skydrive or drop box allow direct access from the cloud, but if you can get networked or a shared drive on a server you should be okay to share. The only thing I would suggest is that you split the database into front end (FE) and back end (BE) - that way you have one copy of the BE on a shared server, and two copies of the FE - one for you and one for your other user. By doing this, you can develop reports, forms, etc free from the exclusivity constraints Access puts on the FE when others are in the database.

Hope this helps.