Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How To Automate a Secured Access Database Using Visual Basic
Article ID: 192919 - View products that this article applies to.
This article was previously published under Q192919
There is no Automation method in the object model of Access that allows Visual Basic to open a secured Access database without getting a prompt requesting a username and password. However, it is possible to accomplish this using the Shell command. This article demonstrates how to open a secured Access database without getting a prompt.
There are two ways to secure a Microsoft Access database:
Step by Step Example
For additional information, please see the following articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/132143/EN-US/ )ACC: Overview of How to Secure a Microsoft Access Database
(http://support.microsoft.com/kb/235422/EN-US/ )ACC2000: How to Open a Password-Protected DB Through Automation
(http://support.microsoft.com/kb/147816/EN-US/ )ACC: Using Microsoft Access as an Automation Server
Article ID: 192919 - Last Review: January 23, 2007 - Revision: 5.4