Hi all,
Thanks in advance for your help with this dilemma. I have a form, which upon the click of a button runs vba code to iterate through a bunch of log files in a directory (FileSysObject), and vaccum the contents into my db.
When I run this process from outside of access, using an .exe file, it takes less than five minutes. When I try to do this from within access, it takes 35 - 40 minutes. Anyone have an idea how I can increase my performance?
Please see the VB code attached in the zip. The code is the same, except instead of setting the ADO connection object to the physical address of my file, I use:
Set Conn = CurrentProject.Connection
I have also tried using DAO, and the results are the same.
Thanks in advance for your help with this dilemma. I have a form, which upon the click of a button runs vba code to iterate through a bunch of log files in a directory (FileSysObject), and vaccum the contents into my db.
When I run this process from outside of access, using an .exe file, it takes less than five minutes. When I try to do this from within access, it takes 35 - 40 minutes. Anyone have an idea how I can increase my performance?
Please see the VB code attached in the zip. The code is the same, except instead of setting the ADO connection object to the physical address of my file, I use:
Set Conn = CurrentProject.Connection
I have also tried using DAO, and the results are the same.
