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 ET and before 8 AM ET 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 |
Resources:
http://msdn2.microsoft.com/en-us/library/bb188204.aspx
http://www.sql-server-performance.com/access.asp
Related Topic Keywords
For articles on related topics, double-click and copy any word or phrase on this page and paste into the Knowledgebase Search to the left