Tag Archives: Sharepoint

Preparing your Access database for the web

Posted on October 8, 2014 by Matt

Preparing You Access Database for the Web

Have you considered running your Access Database on the web with Sharepoint and Access Services?

Access Services does not support all the data types, relationships, objects, or events that the full Access client provides. If you’ve created a web database from the start, only the supported elements will be shown during the design process. For those who have not created a web database from scratch, it is still possible to get your regular Access database up to the web with Access Services.

Access 2010 includes the “Web Compatibility Checker” tool. This tool checks the web compatibility of the tables in a database as well as web objects. However, the tool does not check any data within the actual tables and does not check linked tables from other data sources.

The goal of this tool is to make sure that the database is “web-legal” and to get you up and running with Access Services in a functional manner.

To run the Web Compatibility Checker tool in Access 2010:

1. Go to FILE > Save & Publish
2. Click “Publish to Access Services”
3. Click “Run Compatibility Checker”

Once you’ve completed this process and fixed any errors, the next step is to get the database up to a Sharepoint server.  You can get up and running with a Sharepoint 2010 Enterprise server for as low as $49 per month from AccessHosting.com

Posted in Access 2010, Access 2013, Sharepoint 2010, Uncategorized | Tagged , | Leave a comment