Button to open another access database

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good afternoon,
I have 1 database that our squadron
uses "upstairs", "downstairs" uses another one both access
2k and win2k. I would like to create a macro on the
downstairs database that would open the one upstairs. The
one upstairs is secured and uses user names and
passwords. For some reason this is not working for me. I
am using the runapp action and here is the command
line: "C:\PROGRAM FILES\MICROSOFT
OFFICE\OFFICE\MSACCESS.EXE" "\\2MAWCPQ1S3L03\TRAINING
DATABASE\VMAQ-1 DATABASE.MDB" Any help is greatly
appreciated. Thank you for your time.

Respectfully,
Mike
..
 
Try:
Create a shortcut to the secured DB referencing the MDW
file that it uses and call the shortcut. or try the shell
function within VBA but either way you will need to tell
Access where the MDW file is located if the DB is secured.

I hope you are not training guards inhumanely and
illegally hold "detainees" (including children) at
Guantanamo Bay
 
Back
Top