Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Question Unanswered: How do i run a macro in a different, PW protected database in VB?

    If anyone can help I'd be very grateful!! There are two databases involved - the datasource and calculations database and the recipient db. I need to run all the queries and macros in the first and then put the results into a table in the second - which is password protected. I can't take the password off because I don't want other users to be able to access the db (it's the back end to a different piece of software). I have all the macros and queries written and am opening the 2nd db using the shell command... but I haven't a clue how to write the pw into it

    Many thanks,

    Grey

  2. #2
    Join Date
    Aug 2004
    Posts
    2
    ...it's in Access2000 by the way. Can I use the /pwd switch with the shell command?

    Thanks!

    Grey

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •