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.
Problems with transfer of Emails from MS Access to Sharepoint Lists
I have a real issue, I just cannot solve. I try to export a Microsoft Access Database to SharePoint. However, exporting is not possible because of Email addresses included in a table (the datatyp of the field is link). The error is always: "Cannot send to server. The URL is either not valid or longer than 255 characters". If I directly enter an email address in sharepoint, I have no problem. I would appreciate any support, feedback, hint, as to how I can get my list of email adresses from MS Access to SharePoint. Many thanks mahu01