Access 2000/2003 VBA - opening another database

[Trent]

I have 2 access databases and at a point of execution
database A opens up database B. The problem is when I
stop the sequence of code database B remains open, but is
no longer visible. Even having global variables does not
fix the problem. I shouls note that this was only
encountered in Access 2000, not Access 2003. Any
suggestions?

 

[Naresh Nichani MVP]

Hi:

Assuming you have a variable called objAccess of type Access.Application try
this line --
objAccess.Visible = True

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Trent]

It seems like that would be the answer, but what I've done
is to open and display the database making the opened
database visible. What is at issue here is how 2000 and
2003 clean up their variables after the particular
module/class has closed. 2003 will leave database B open
when database A closes but 2000 will close database B when
database A closes. If there were a way to spin off
threads or new instances in 2000, I feel I would be able
to solve this particular problem.