Access Remains open after a Mailmerge using Visual basic
Posted on 2006-10-30
I have a VB6 program that: opens one access97 database. Purges the second access database, Gets some data and puts it into the second access97 database. And does several mail merges into different templates from the second database.
The second database opens itself in an access window and stays open. This program runs everyday and if you forget to check the server, many instances of the access database remain open - hogging resources.
I have tried DBase.close, recordSet.close, WordApp.close.
I have other programs which do similar things but dont open the DB window. and I cant see the difference between it and the other program. I dont know alot about VB
All help is greatly appreciated.