OPEN 2nd DATABASE

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I would like to use code to do the following:

From an open Access 97 database, use code to open a
password-protected second database in run-time mode, and
then close the first Access 97 database. I need to end up
with the first database closed and the second database
open and in focus. Is there code that will do this?

I know how to use code in a shell function to open the
second database in run-time mode. I also know how to do
code with OpenDatabase that opens the second password-
protected database with code, but not in run-time mode.

I need to do them both, but can't get anything to work.
Thanks for any help.
 
Try the FollowHyperlink method to open the new database, and then
Application.Quit to close the original one. It works in Access 2000, but I'm
not sure about Access 97.

HTH
Adam
 
Back
Top