Using Microsoft Access with ODBC

Rules, Considerations and Tips for Using Access with Your ODBC

Using Microsoft Access to connect to your XenDirect data via an ODBC connection can have an effect on the performance users experience when adding, modifying and searching XenDirect data. Here are some general rules and tips for using Microsoft Access as your ODBC connection.

Topic	Read Only ODBC	Full Edit ODBC
Time of Day	Any time of day	Between the hours after 5 PM and before 8 AM except when being used for scanning uploads
Effects on Users	Can have some performance degradation depending on the longevity of the query. Users accessing the same data site from where the query is running may see performance degradation. All users may experience performance degradation if the query is very complex and takes more than a few minutes to run.	Can have some performance degradation depending on the longevity and type of the query. Delete, append, and update queries lock tables while running. Users accessing the same data site from where the query is running may see severe performance degradation. All users may experience severe performance degradation if the query is very complex and takes more than a few minutes to run.
Suggestions	Tell other users when using ODBCDownload data locally first, then run queries from downloaded data Consider other query and reporting products (Xenegrade is researching for products that do not hinder performance)	Tell other users when using ODBCDownload data locally first, then run queries from downloaded data Consider other query and reporting products (Xenegrade is researching for products that do not hinder performance) Use when XenDirect users are not online