I am using Access 2003 for this project. I have a database which has linked tables to 5 other databases. This databash crashes often and I have already gone through most of the famous steps for crash prevention. I came across the article below and need to know if my understanding of it is correct and if there's a fast way to implement amongst a lot of users.
It seems like this article is saying that instead of doing the traditional link to a table in another Access database I should: Go to the control panel's ODBC administrative options and create Access ODBC data source on each PC. Then within the main access database link to these ODBC connections (instead of linking directly to the other Access database.) Do I have this right?
When you run Microsoft Jet in an IIS environment, it is recommended that you use the native Jet OLE DB Provider in place of the Microsoft Access ODBC driver. The Microsoft Access ODBC driver (Jet ODBC driver) can have stability issues due to the version of Visual Basic for Applications that is invoked because the version is not thread safe. As a result, when multiple concurrent users make requests of a Microsoft Access database, unpredictable results may occur. The native Jet OLE DB Provider includes fixes and enhancements for stability, performance, and thread pooling (including calling a thread-safe version of Visual Basic for Applications).