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

Hi,

Out of interest why did you decide on an Excel front end? Was it due to Access not being installed on client machines?

How many concurrent users do you currently have?