Deco

I've got a module in database 2 which runs when the database 2 is opened. When it has finished the database closes down. What I would like to be able to do is to open database 2 from database 1 to run this module, close database 2 and keep database 1 open. I would appreciate if one of you experts out there could advise me if this is possible and if so how do I do it.

Many thanks

Thinker

I must assume you are referring to Access, and you are using VBA
for the programming. You would have to use automation to open
a second instance of Access with database2 loaded. I also guess
that if the sub runs automatically when opened normally, it will
under this method also.

Deco

Yes I'm using VBA within Access. I've tried what you said (see code below) and when I step through the procedure it appears to be working but nothing actually happens.
Any ideas?????

Cheers


Private Sub Command0_Click()
Dim dbs As Database
Dim dbImport As Database
Dim strdb As String
Dim wrkJet As Workspace

Set dbs = CurrentDb
Set wrkJet = DBEngine.Workspaces(0)

MsgBox "Opening"

strdb = "G:\reinledg\Midnight\697LPC\LPCCashImport.mdb"

Set dbImport = wrkJet.OpenDatabase(strdb)

End Sub

Thinker

You aren't opening a second copy of Access with automation, you
are just opening a database object with DAO. You would have to
use the CreateObject() function to start a new instance of Access.

ooosadface

Yes, thank you...
I'd been looking for this for a couple of days now. I had been opening other databases from a .bat file. Where I work, we have slowly (somehow) started using three different OSes (98, NT and 2000) and the minor differences in the .bat file were annoying me. I now have is switched to VB(A) and it is due to Thinker pointing out the CreateObject() function to start my other instance of Access. From there I loaded my database into it with the GetObject() function and all is well. So much easier than the .bat file.

Thanks for your help Thinker (even though you didn't know you were helping me!)