Keeping Access files on a SharePoint site??
Hello: I work as a research scientist and I keep a substantial amount of data in Access databases. I use both a virtual machine and a laptop to work with those databases. Using the VM is helpful because I can disconnect my laptop from my employer’s network without disrupting a long-running job. Because I use two machines I would like to keep them in one network location so that both machines are able to access (no pun) my databases. Keeping them in one spot will save me from wondering which file is the most current. I learned the hard way to never store Access databases in a location that synchronizes (such as Offline Files or OneDrive), because the database will be damaged if synchronization occurs while I have the file open. I have seen “hints” that it might be OK to store an Access database on a SharePoint site without the database becoming corrupt. Is this correct, and do I need to “check out” the database so that the other machine cannot open it? My network is slow, so I likely will have to download the Access file from SharePoint to work with it. Access Web Services are not available, and I do not want to use SharePoint lists because (as I understand it) SharePoint lists do not: support unique composite keys; the difficulty transferring Access tables to lists; the learning curve. Any suggestions or thoughts? Thanks in advance.