CODEWITHSUNDEEP
sql-serverms-accessssisoffice365etl
sydney
sydney

Reputation: 131

Unable to connect to protected Access DB in SSIS

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:

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

Upvotes: 0

Views: 407

Answers (2)

Hunter Kingsley
Hunter Kingsley

Reputation: 61

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.

Upvotes: 0

Hadi
Hadi

Reputation: 37313

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

Upvotes: 0

Related Questions