Database Reference
In-Depth Information
CHECKING WEB COMPATIBILITY
Before publishing a Web database to a server, you should run the compatibility checker, as shown in Figure E-24,
to identify any problems that might prevent the database from working correctly. If the compatibility checker finds
any problems, you can correct them before publishing the Web database, and then run the compatibility checker
again to be sure that you made the correct changes. The following steps check the Web compatibility of the Reps
and Customers database before publishing it.
388
Publish to Access
Services button
Run Compatibility
Checker button
Message indicates
the database's compatibility
with the Web
Save &
Publish tab
FIGURE E-24
Checking Web compatibility for a database
1. On the Ribbon, click the File tab, and then click the Save & Publish tab.
2. Click the Publish to Access Services button in the Publish area, and then click the Run
Compatibility Checker button to check Web compatibility.
If you have followed the steps in this appendix correctly, you should see a message below the Run
Compatibility button indicating that the database is compatible with the Web, as shown in Figure E-24.
Q&A
Question: What should I do if the database is not compatible with the Web?
Answer: Click the Web Compatibility Issues button to see the specific issues you need to correct. For each
issue, click the link to display information describing how to correct the issue. The most difficult issues to
correct are existing relationships, which Web databases implement using lookup fields. To fix a relationship
issue, delete the relationship, and then add the appropriate lookup field to replace it. Run the compatibility
checker again to make sure that you corrected all of the issues.
PUBLISHING A DATABASE TO A SERVER
After confirming that the Reps and Customers database is compatible with the Web, you can use the Save &
Publish tab, shown in Figure E-25, to publish the Web database to a SharePoint Server using Access Services.
Before publishing the Web database, you will need to enter the URL of the server that you will use to host the
Web database and the site name. The full URL for the Web database is the combination of the server URL
and the site name. After you have entered the complete URL on the Save & Publish tab, the Publish to
Access Services button becomes available.
