@saltedcaramel said in CRM or MS 365?:
@scottalanmiller
Thanks.
I've started using Google drive, One Drive, Drop box for saving files and spreadsheets. However I'm having issues with both excel spreadsheet files and MS Access files. Firstly when I open and edit Excel files, Google, one drive, drop box, they all seem to save additional copies every time. Why is this? How can I get it to simply over-write the file I'm working on so there's only one document each time?
Also once I upload an MS Access file, each time I click on it, it saves a copy on my hard drive. Why is this and how can I get around it?
Access is not meant to be used like that. And generally, it is a product to absolutely avoid. If you really want to use Access, you need some serious infrastructure to make it actually work properly and the cost is ridiculous.
Like every user that needs to use it needs Access licenses bought for them. And you need to run a SQL Server instance... there is no proper way to use Access over the internet without connecting it to a Sharepoint server to host the web interface.
Without a Sharepoint and SQL Server infrastructure, you have to rule out Access.