Can Total Visual Agent run a macro on a database with a password?
No. Total Visual Agent can successfully launch a macro in your database if it has workgroup security or doesn’t have a password. However, Microsoft Access does not provide a way to open a password protected database using command line arguments. Total Visual Agent only launches Access with your database and designated macro. It cannot respond to any prompts or other dialogs that appear as a result of your macro, such as a database password.