Unable to connect to protected Access DB in SSIS

Question

I have an Access DB (part of Office 365) with extension (.accdb). This database is protected by a password. I'm trying to create a connection to this Access db in SSIS but it keeps failing when I do a "Test Connection".

I'm using the following provider in my connection:

1. Native OLE DB\Microsoft Office 12.0 Access Database Engine OLE DB Provider
2. In the "Jet OLEDB:Database Password" under the "Microsoft.ACE.OLEDB.12.0" section, I enter the password.

But when I click "Test Connection", it fails.

I basically followed this link:

• Password Protected Access DB and SSIS

The error message is:

Test connection failed because of an error in initializing provider. Cannot open database. it may not be a database that your application recognizes or the file may be corrupt

Does anyone know why?

Thank you

Answer 1

The main error is:

Cannot open database. it may not be a database that your application recognizes or the file may be corrupt

So i don't think it is a password related error, it sounds like your database is corrupted. Try opening the database manually, run the Compact and repair process, and Save As new copy

Helpful articles

• Where is Compact and Repair in Microsoft Access 2007, 2010, 2013 and 2016
• Fix MS Access Database Error 3049: Cannot Open Access Database
• Cannot open database “. It may not be a database that your application recognizes, or the file may be corrupt
• Compact and repair a database

Answer 2

In Access, I get the error 3049: Cannot open database '' when I'm adding bulk records and specifically when these records have Access attachments. These attachments are stored as a byte array and may be rather numerous and each could be sizeable - a megabyte for a picture is not uncommon. When I exceed 2GB of Access database size, the error is 3049 and it can happen quite randomly.