Share via

Open another Access file from within Access

Anonymous
2015-03-23T16:06:37+00:00

Hi,

Have two Databases.   1 and 2.

I found a way in my books to open another Access file (Database) within Access using a command button on a form:

Example.  In Database1:

Application.FollowHyperlink "C:\Users\Amy.GNA.000\Desktop\DATABASES\Database2.accdb"

This works and opens Database2.  But is there a way to save & close Database1 in the same procedure or maybe in the startup of DB2?

Currently Database1 remains open after DB2 opens.  Would rather not have both open and running.

Thank-you for your time and any suggestions,

Amy

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-03-23T16:12:53+00:00

You should be able to follow the Application.FollowHyperlink line with a line

Application.Quit

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-03-23T21:32:12+00:00

    Good... now I can Quit early today!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-23T17:09:03+00:00

    Hello Mr. Vinson,

    Works perfect!

    Thanks a lot,

    Amy

    Was this answer helpful?

    0 comments