I have an Excel 2007 project in VB.net that talks to a backend Access database using the connection string below. There are now 2000 records in the main table used in the database and the processing takes almost a minute just to open one form. What sort of thing causes this? How can I speed this up?
Dim ConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & oFullPath & ";"