ADODB Connection
 

I have created a userform with listbox to show Access database results
in a listbox.

If Access database has less data it pulls out data very fast.

Otherwise it takes long time to get results.

I am using this code to get data from Access database to Excel listbox

Set Conn = New ADODB.Connection
dbname = "C:\database1.accdb"
Conn.Provider = "Microsoft.ACE.OLEDB.12.0"
Conn.Properties("Data Source") = dbname
Conn.Open
..................................

How can i get the data fast ?

Any suggestion, answer.....