Slow ado opening with large Access Database

[Paul D]

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.....

[Negative0]

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

[Paul D]

My connection string is...

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\mydb.mdb

???