Shell code to open MDB file

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

I would like to push a button in DB1 to Open DB2.mdb and
bring it up as if I clicked on the icon on my desktop.

I would then like to close DB1 through code that would run
on DB2's open (through a macro AutoExec).

The Shell command will not let me open a .mdb file. Any
suggestions?

Katrina
 
The shell command should work..but does requite a long complicated path to
the msacces.exe.

I would dump the use of shell..and use

Application.FollowHyperlink "c:\my documents\db1.mdb"

The above can be used to launch any file...as if you clicked on it. So, to
launch a word doc you coul use:

Application.FollowHyperlink "c:\my documents\MyWordDoc.doc"
I would like to push a button in DB1 to Open DB2.mdb and
bring it up as if I clicked on the icon on my desktop.
Click to expand...

That is easy..you can use:
Application.FollowHyperlink "c:\database\db2.mdb"
I would then like to close DB1 through code that would run
on DB2's open (through a macro AutoExec).
Click to expand...

Now, that is very difficult to do. Why not just have mdb1 quit right after
it loads the mdb2?

I would simply just quit the application like:

Application.FollowHyperlink "c:\database\db2.mdb"
application.quit
 
Back
Top