Running a Macro on a database that has MDW security

[Pepi]

I have an overtime database that requires the users to login via a separate security MDW database. Every Friday, I need to run a Macro to zero out a table in the overtime database. Is there anyway I can get around the prompt to login so I can run the Macro by the Windows task scheduler? I have full access to the overtime database.

Thanks!

Shortcut used:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\files\Common\Apps\Overtime\OVERTIME.MDB" /wrkgrp "\\files\Common\Apps\Overtime\secured.mdw"

 

[apr pillai]

You can add /user UserName /pwd Password options to the shortcut (if you are using Access2002-2003).

 

[CJ_London]

if you want to run a query from your database to open the MDW database and delete the contents of the table, you can do it using ADO which allows you to state the password as one of the parameters.

Alternatively, if you are allowed to do this, create a linked table object in your db to the mdw db, you'll be prompted once for the password when you create the link.