Why does my ado connection to my access database
open so slowly (approx 1min). The database is large
(14Mbytes) however using the DAO data control loads it
under 5 seconds ???? I am using Jet 3.51 in my connection
string.....
Printable View
Why does my ado connection to my access database
open so slowly (approx 1min). The database is large
(14Mbytes) however using the DAO data control loads it
under 5 seconds ???? I am using Jet 3.51 in my connection
string.....
What exactly are you using for your connection string,
I use this command and it opens quick
code:
DB.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & App.Path & "\DB.mdb"
DB.Open
My connection string is...
Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\mydb.mdb
???