I have a database that needs to be used by several people in different geographic locations. My thought was to split the database and put the backend on SharePoint. I seem to be having three different issues with this and would appreciate guidance:
1. When I split the database, it puts the backend in the same location as the front end and I can't find where to modify the location to a SharePoint web address.
2. When I try to publish to SharePoint, the wizard automatically puts the database objects in a generic folder instead of the one I specified. Is there a way to tell Access which folder to put the database in?
3. Some of the functions do not appear to work when they are on SharePoint (crosstab query, for example). Is there a way to overcome this?