How do I keep the Pervasive tables linked via ODBC from making my Access databases crash?
Posted on 2007-12-05
We have implemented Sage/Timberline software that runs on a Pervasive db platform. We have several Access databases that cull information from our old system, Intuit Master Builder. In order to produce accurate information and reports, I must combine the data from both systems. The most practical way of using the Pervasive tables is to link them via ODBC and we have the drivers to do that. In all of the databases that use the linked tables, I created a macro to delete that table, then re-link via ODBC to refresh the tables prior to the queries. After I created this macro, my Access databases started to crash either in the middle of being used or following their closing. I prompt all of my Access databases to compact on close. I need to know how to stop this problem. Thank you