2 user level passwords and a system password still can't run avbscript

I have a security issue and it involves a vbscript where I'm trying
to automate compacting a database. I have the script which looks like
it should run but I get password errors. I thought it might be
because the vbscript needs the database password to run automatically
so I set a database password. In that case the script brings up the
user level password/login dialogue which I don't want because I want
it automated whereas it should take the database password and proceed
automatically? I enter the developer user level password that I have
and it says error not a valid account and password for the vbscript.


line of vbscript with database password:
objAccess.DBEngine.CompactDatabase strPathToMDB, strTempDB,
";pwd=Kiyote#3"

so then I just unset the password thinking it will accept the
developer login and password which is seems to be asking for but in
this case I get the error message "not a valid login and password". I
also try this with the other admin password.
objAccess.DBEngine.CompactDatabase strPathToMDB, strTempDB

So my conclusion is that I have to give the priveledge to run the
vbscript to the system password somehow?
There are only 2 user level passwords known to me. The user does not
remember anything else.
One is admin and the other is developer. The developer password has
the ability to change all objects except the database object. The
admin user has access to all objects except in database object "modify
design".

There appears something wrong with the fact I can't use the system
database password to run the script and that it brings up the user
level password dialogue?

thanks,