Connection failed error on initialization

Asked By rubiagguire 0 points N/A Posted on - 02/02/2012

Hi,

I need some information about the following error:

Microsoft Office 12.0 Access Database OLE DBO Connection Manager Error.

Connection Manager

Test connection failed because of an error in initializing provider. Unrecognized database format 'C:UsersPWF1DesktopVEICBook1.xlsx'

Help me please.

Thanks a lot.

• Status: Open
• Question Views: 2197
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Michelle Bang

Go To Solution

Best Answer

Best Answer

Answered By Michelle Bang 55 points N/A #97072

Connection failed error on initialization

There is one simple explanation to this. I have also done a lot of work in SQL and access database.

1. This error normally comes when you are trying to open an access database in SQL or at any other software which is made in higher version. For example you are trying to make a connection you are using a 2007 access file but you are using a 2005 SQL or any other software.
2. either save the file in 97-2003 access format which will be xls and not the xlsx or install some access engine exe from the website.
3. Download the access database engine driver form here. Install these drivers, restart the computer and then try to make the connection.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 02/06/2012
• Question Category: MS Access

Answered By rubiagguire 0 points N/A #97073

Connection failed error on initialization

I had tried both of your suggestions Michelle Bang and you are correct. I tried to save it 97-2003 format and it became readable.

I also installed the database engine and I was able to make the connection. Thanks

About rubiagguire

Questions
8

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Access