When extensive changes have been made to an Access database, or you are converting an existing application to Scriptoria, the following guidelines are strongly recommended.
Perform a repair database operation. This can eliminate some rather cryptic errors that can occur when analyzing the database. (Tools | Database Utilities | Compact and Repair Database)
Perform an analysis of the database (use the Access “Tools | Analyze | Performance” menu item). Analyze all tables, queries, and forms. SQL Server Performance can be greatly improved by creating indexes and relationships suggested by the Performance Analyzer.
ODBC linked tables are not updateable unless they are assigned a unique index or primary key.
Use the High Overhead Queries report to identify queries that may exhibit post-migration performance degradation.