I am using a split database with an encrypted back end. Both front and
back ends are Access 2007 .accdb files. Everything seems to work fine
from within Access, and I can compact and repair the back end after
opening it in Access and supplying the password.

I am now trying to set up a command line to compact and repair to
happen nightly after data updates, and am running into difficulty with
the password. I am using the following syntax on the command line:

"c:\path\msaccess.exe" "c:\path\db.accdb" /compact /pwd xyz

If I omit the final "/pwd xyz", access requires me to manually enter
the encryption key and the compact & repair seems to work fine.
However this will not work for un-attended operation.

If I include the final "/pwd xyz", access displays a logon dialog with
my user name in it, and asks for a password. If I type in the
encryption password (xyz in this example), it does not work.

What am I doing wrong? Is there a different command line switch for
encryption passwords?

Thanks!

On Fri, 19 Feb 2010 05:47:19 -0800 (PST), Whit <(E-Mail Removed)>
wrote:

From the A2007 help file:
/pwd password Starts Access by using the specified password. Applies
to Access 2002-2003 and earlier databases only.

Unfortunately that page does not show what the correct switch would
be.

-Tom.
Microsoft Access MVP


>I am using a split database with an encrypted back end. Both front and
>back ends are Access 2007 .accdb files. Everything seems to work fine
>from within Access, and I can compact and repair the back end after
>opening it in Access and supplying the password.
>
>I am now trying to set up a command line to compact and repair to
>happen nightly after data updates, and am running into difficulty with
>the password. I am using the following syntax on the command line:
>
>"c:\path\msaccess.exe" "c:\path\db.accdb" /compact /pwd xyz
>
>If I omit the final "/pwd xyz", access requires me to manually enter
>the encryption key and the compact & repair seems to work fine.
>However this will not work for un-attended operation.
>
>If I include the final "/pwd xyz", access displays a logon dialog with
>my user name in it, and asks for a password. If I type in the
>encryption password (xyz in this example), it does not work.
>
>What am I doing wrong? Is there a different command line switch for
>encryption passwords?
>
>Thanks!

On Tue, 23 Feb 2010 07:06:07 -0700, Tom van Stiphout
<(E-Mail Removed)> wrote:

I just dug a bit deeper and the news is not good:
http://support.microsoft.com/kb/161177

-Tom.
Microsoft Access MVP


>On Fri, 19 Feb 2010 05:47:19 -0800 (PST), Whit <(E-Mail Removed)>
>wrote:
>
>From the A2007 help file:
>/pwd password Starts Access by using the specified password. Applies
>to Access 2002-2003 and earlier databases only.
>
>Unfortunately that page does not show what the correct switch would
>be.
>
>-Tom.
>Microsoft Access MVP
>
>
>>I am using a split database with an encrypted back end. Both front and
>>back ends are Access 2007 .accdb files. Everything seems to work fine
>>from within Access, and I can compact and repair the back end after
>>opening it in Access and supplying the password.
>>
>>I am now trying to set up a command line to compact and repair to
>>happen nightly after data updates, and am running into difficulty with
>>the password. I am using the following syntax on the command line:
>>
>>"c:\path\msaccess.exe" "c:\path\db.accdb" /compact /pwd xyz
>>
>>If I omit the final "/pwd xyz", access requires me to manually enter
>>the encryption key and the compact & repair seems to work fine.
>>However this will not work for un-attended operation.
>>
>>If I include the final "/pwd xyz", access displays a logon dialog with
>>my user name in it, and asks for a password. If I type in the
>>encryption password (xyz in this example), it does not work.
>>
>>What am I doing wrong? Is there a different command line switch for
>>encryption passwords?
>>
>>Thanks!