Connection String for the Microsoft Access 2010 with password protected

• Question

• 

  

  0

  Sign in to vote

  When I use a Access database version 2007 or earlier (MDB) I use the following connection string: 
  Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=c:\folder\file.mdb;Mode=Share Deny None;Persist Security Info=False;Jet OLEDB:System database='';Jet OLEDB:Database Password='xxx';
  This connection string above works with files that has a password or not. 
  
  Now I'm going to use Access version 2010 (ACCDB) and checking the microsoft msdn I just swapped the string:
  Provider=Microsoft.Jet.OLEDB.4.0
  By this:
  Provider=Microsoft.ACE.OLEDB.12.0
  
  When I do test on my local computer, the string works ok for files with or without the password. 
  However when I test in the web server only works with unprotected files (WITH NO PASSWORD) when I use a protected database, the error is shown below. 
  
  Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
  
  Could you help me with a connection string that will work with an Access 2010 file protected with password? 
  Thank you.

  • Moved by Amanda Zhu Monday, September 1, 2014 2:09 AM

  Monday, August 25, 2014 2:40 AM