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

Accessing password protected Access database using OLEDBCONNECTION

Dear Experts,

I have an access 2003 database that I have set a password on. I have used the connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Development\ME\CartSync\CartSync\bin\Debug\Database\cartsync.mdb;User ID=Admin;Password=12345

but this won't connect.  If I remove the password from the databsae and the connect string it works.  I know the password is correct as it asks for it when I open the database up in access.

Any ideas?
0
watersidedesigns
Asked:
watersidedesigns
1 Solution
 
TimCotteeCommented:
This should do it.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Development\ME\CartSync\CartSync\bin\Debug\Database\cartsync.mdb;Jet OLEDB:Database Password==12345
0
 
watersidedesignsAuthor Commented:
Many thanks Tim - that did it (should only be a single ='s though)

Thanks again for a very very quick response :)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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