Dashboard That Links to Multiple Databases

[GooberFish]

I have been working on a design composed of a single dashboard that links out to multiple databases. The databases are unrelated to each other.

When a user selects a category from the dashboard, the user is taken to the database that contains records for that category. Upon making a selection, the dashboard minimizes.

I used VBA coding to make this go. I would like for the selected database to open in the same session as the dashboard; at present, Access opens a new session each time the user selects a database to view. The result is a little clunky.

I would appreciate ideas or code that will give us the same-session functionality that I described above.

Thank you!

Q.

 

[GregRun]

Unless I'm somehow mistaken, there is no way for one Access Application Object to simultaneously have two databases open. You're probably better using linked tables to get to the data in your external databases.

Can you explain how this process is clunky (what specifically do you not want the user to see)?

For example, in a Domain environment, opening a new access database causes a login window to appear. You can skip that login window using this code:

Using a string variable "YourDBPath" to represent the path you will assign on the fly based on the dashboard selection.

Shell SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE """ & YourDBPath & """ /user """ & CurrentUser & """", vbMaximizedFocus

 

[GooberFish]

By login window, do you refer to the Access start-up sequence, or something else?

Thanks.

Q.

 

[GregRun]

Yes.

And I'll just quote myself here instead of asking again.

Can you explain how this process is clunky (what specifically do you not want the user to see)?