Automation and DBEngine

[Hmadyson]

I am setting up an Excel workbook that launches access databases and then closes them. I use the DBEngine because some of these databases have security around them.

I have found that using the OpenDatabase method in DAO does not do what I want it to do. It also opens up Access sessions in the background, which I am unable to close.

I have been shelling open the database (so that I can use the security anf full command line), and I can get the object, but I can never close it and quit the access session it is in.

I have read everything on Microsoft.com that has to do with this, but I am still stumped.

Thanks for any help.

 

[Hmadyson]

I forgot to mention that when I launch these databases from Shell, my DBEngine object gets corrupted, and stops working.

 

[vbajock]

What's the purpose of opening and closing the databases?

 

[Hmadyson]

I am actually trying to open Access 97 databses in Access XP without converting them, so that users will not get the convert message when they open them.