Hello!  In my college years I took an accounting class that taught me how to create an Access database.  Years later I am using that knowledge for a small business I work for.  

I have one small section of the database complete (creating customer quotes) and I'd like users to be able to use this function while I continue to work on the database.  In fact, I plan to continuously update the database as long as I work here.  

If I put the database on our shared network, only one person can currently be in the entire database file at one time for editing (we currently have Access 2010 installed on all of our machines).  I would like multiple users to be able to edit the same quotes form at the same time and for everyone to see eachother's updates in real time.  

I would also like to make improvements to the quotes form as they are using it (add emailing functions, etc).  

I tried the SkyDrive, but Access is not supported.  Do we all need Office 365?  Do I need to split the database?  I am hesitant to publish to sharepoint, because A. I don't think we currently have a sharepoint platform and B. I don't know anything about it.  Do you have a good suggestion for me?  

Many thanks!!

---

Reply from Richard Rost:

If you are all in the same physical location (office) then you should all be allowed to access the database at the same time. Make sure you're not opening the database for EXCLUSIVE access. Ideally, yes, you should split the database into front-end and back-end files, but you don't need SkyDrive, Sharepoint, or any of that stuff. Sharepoint is if you need to create a WEB-based database for people in different physical locations to use at the same time.