Data Center & Security
Do you have questions or need help?
Latest Blog Posts
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