• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Connect to password protected DB

Happy Holidays all,
I am working on an upgrade to an existing outlook form. I am using recordsets to sent the data from the form to product specific databases. Currently I am trying to integrate a database that wasn't designed to work with this form. I am having one issue, and that is connecting to the DB because it has a password (all the other ones don't) I have attached the code for how I was connecting to the none password DBs. I tried the macro builder in excel to give me the base code for connecting but that didn't work. Thanks for your help. I know this is an easy one but I am drawing a complete blank and haven't found any real help online.
cn8.Open "Provider= Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=G:\Power\Access\Power Plant.accdb;"

Open in new window

0
thediplomat87
Asked:
thediplomat87
1 Solution
 
LordArokhCommented:
Hello TheDiplomat87,

You can check the link below :

http://www.connectionstrings.com/access-2007

There are various connection strings to any type of servers which includes password protection also.

Cheers

TK
0

Featured Post

 Email signature solution for Office 365

Easily set up a company-wide email signature in Office 365 that works with every email client. Add personalized email signatures to every email in your company. Let users preview their server-level signature in Outlook.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now