Help
I'm developing a VB6 application to enable automated daily export from several access databases in to oracle.
I'm having no problem connecting and exporting the data from an individual db, and if the application is closed and run again a different db can be exported.
My problem is that I cannot run them back to back.
The cause of the problem appears to be that the DBEngine security file is not being released by the code despite it being soley declared within a function.
Does anybody know how to refer to multiple security files using the DAO DBEngine.
Any help would greatly ease my banging of head against monitor.
I'm developing a VB6 application to enable automated daily export from several access databases in to oracle.
I'm having no problem connecting and exporting the data from an individual db, and if the application is closed and run again a different db can be exported.
My problem is that I cannot run them back to back.
The cause of the problem appears to be that the DBEngine security file is not being released by the code despite it being soley declared within a function.
Does anybody know how to refer to multiple security files using the DAO DBEngine.
Any help would greatly ease my banging of head against monitor.
