Thread: Performance accessing data in a linked database using ADODB in Excel

Hello,

I have an excel application (front end) that connect to an access database using ADODB. Recently I had a locking incident that prohibited other users from changing data in the tables, so I was thinking of using the split database feature in access, and it works fine, but it has increase the times for queries by almost double. I read somewhere that to speed up the connection between the front end database and the bankend database you need to keep a connection active all the time using DatabaseOpen? I am not very familiar with VBA in Access. Using ADODB I close the connection after each query, would keeping it open help? Any suggestions would be appreciated.

DrD