F
fi.or.jp.de
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.....
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.....