I use the following code in a function to test if a database is open
AppActivate pasDBName, True
In ACC2003 and WindowsXP ths worked great, but alas in ACC2003 amd Vista it opens a new Acccess Application that is not shut down when the function is closed. This creates all kinds of issues as it creates an Access window that cannot be closed except by usng the Task Manager.
The application opened is not the current applicatiion, that is the database that runs the code. So I'm lost (as usual). Is there anyway to shut this new Acccess application in code?
Thanks for your help.
AppActivate pasDBName, True
In ACC2003 and WindowsXP ths worked great, but alas in ACC2003 amd Vista it opens a new Acccess Application that is not shut down when the function is closed. This creates all kinds of issues as it creates an Access window that cannot be closed except by usng the Task Manager.
The application opened is not the current applicatiion, that is the database that runs the code. So I'm lost (as usual). Is there anyway to shut this new Acccess application in code?
Thanks for your help.
