Good morning, guys!
I'm a beginner in VBA and I'm developing a system in Excel w / Access database that consistis of some queries. Why not only in Access? I need some Excel functions that Access does not have it (or at least I do not know about it). I have some questions regarding access to the database via ADO, that I could not elucidate.
So..
Do I have to open and close ADO connection and recordset objetcs for every access to DB?
Can I use the same variables as Public type in the Connection and Recordset for different parts of the system? Does not conflict on multiple queries and access to DB?
Is there any technical routine that I have to apply to avoid conflict when there are multiple access to the database?
grateful,
LF
Bookmarks