Database Password - Enter by code.

[Chris O'C via AccessMonster.com]

Re: Can you password protect the BE database and supply the password automatically when linking from the FE?

Yes, you can use the menu to link to the external table in a password
protected db and you'll be prompted for the password. Thereafter the front
end will supply this password every time the linked table is opened in the
front end, like when double clicking on the linked table in the db window.
If you use vba code to connect to the back end, you'll have to supply the
password programmaticall y.

Chris
Microsoft MVP


Bob Alston wrote:

>OK I mean can you use the menu to link to an external table in a
>password protected database and have the front end supply the password
>each time the BE is accessed via the link?

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200808/1

[Chris O'C via AccessMonster.com]

Re: Database Password - Enter by code.

The password you can supply in the shortcut as a command line switch is for
user level security, the one where the user name and user's password are
required. The command line switch for the password doesn't work for the
database password.

Chris
Microsoft MVP


Larry Linson wrote:

>Look in Help for Command Line Options. I am reasonably certain you can
>specify the password in the shortcut you place on the user's desktop, but,
>er, wouldn't that defeat its purpose?
>
Larry Linson
Microsoft Office Access MVP

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200808/1