[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

how can i open with vba on microsoft access a database that is protected with a password

Posted on 2014-03-10
Medium Priority
3,033 Views
hi

i have this code to open a non-protected database
Dim accapp As Access.Application

Set accapp = New Access.Application

accapp.OpenCurrentDatabase d("c:\database\mydatabase.mdb")
accapp.Visible = True


what i have to add to this code to open a database that protected with a password?

thanks
0
Question by:bill201
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 500 total points
ID: 39918203
Some sample code illustrating how to do this:

http://msdn.microsoft.com/en-us/library/ms808201.aspx

Additional help constructing connection strings can be found at:

http://www.connectionstrings.com/

Kevin
0

LVL 6

Assisted Solution

c1nmo earned 500 total points
ID: 39918206
0

LVL 58

Assisted Solution

Gary earned 500 total points
ID: 39918224
Another option, authenticating yourself first then carrying on with your code as normal.

http://support.microsoft.com/kb/235422
0

LVL 61

Assisted Solution

mbizup earned 500 total points
ID: 39918226
With the OpenCurrentDatabase command:

Dim accapp As Access.Application
dim strPwd as string

Set accapp = New Access.Application

accapp.OpenCurrentDatabase ("c:\database\mydatabase.mdb",, strPwd)
accapp.Visible = True

0

Author Closing Comment

ID: 39918290
thanks a lot for  your help.
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month12 days, 20 hours left to enroll