D
dhoover via AccessMonster.com
I have two password protected databases, a main database for user 1 and
another database that has some tables linked back to the main database for
user 2. The second database has a module that loads a form asking if you
want to update linked tables as soon as you are logged into the database.
Each of these databases has it's own seperate user. I need for User 1 to
click a button, open User 2's db, automatically enter the password for the
database, stop the module, run and export a report and then close the second
database. This way User 1 does not have any interaction with User 2's db. I
have everything working except being able to bypass the module that runs
after login; so right now User 1 has to click No at the form that loads from
the module before the report will run and export. Any ideas of how I can
bypass this module? I don't want it to be turned off because in all other
instances, it will need to run automatically.
another database that has some tables linked back to the main database for
user 2. The second database has a module that loads a form asking if you
want to update linked tables as soon as you are logged into the database.
Each of these databases has it's own seperate user. I need for User 1 to
click a button, open User 2's db, automatically enter the password for the
database, stop the module, run and export a report and then close the second
database. This way User 1 does not have any interaction with User 2's db. I
have everything working except being able to bypass the module that runs
after login; so right now User 1 has to click No at the form that loads from
the module before the report will run and export. Any ideas of how I can
bypass this module? I don't want it to be turned off because in all other
instances, it will need to run automatically.