I have connected an Access DB to a VBA-Form
with the API and an ODBC. It works but very slow. Every time that I execute the form the
access is slower than the last one.
What is wrong in my code? -Time out, closing.
Please, Could you help me?
Printable View
I have connected an Access DB to a VBA-Form
with the API and an ODBC. It works but very slow. Every time that I execute the form the
access is slower than the last one.
What is wrong in my code? -Time out, closing.
Please, Could you help me?
How big are the tables (bound to the form) that you're accessing?
Access pulls the entire table into VB environment prior to using it.
Your best bet would be to limit the recordset that you initially import. This should speed things dramatically.
Could you show a code sample?