More than one instance of Access possible?

[hbaggs]

I am trying to develop a simple message book using Access. Unfortunately when I start this database it closes our other Access application. It would seem that what I need is the method of starting a second instance of Access after checking if one is already running?
Many thanx

 

[Rich]

Are you sure it closes and not just minimises to the system tray, how are you openining the second instance?

 

[Pat Hartman]

The application you are starting must be closing the other instance. There is no problem having multiple instances of Access active.

 

[Parker]

A lot depends on how you are opening your second db. You need to start another instance of Access. If you go to the file menu or use a standard commwnd within an already open db then, by default, Access will switch to the new db rather than open another instance. I believe there is a way to change this behaviour but I don't know how and I can't find it anywhere.

If you are using a command button to open another db then include the start up instructions for opening another instance of the application rather than just telling Access to open another db.

Otherwise create a shortcut to open your db directly as another instance of Access.