Excel 2007 ADO Connection Error

P

Paul Faulkner

Hi,

I'm having an intermittent fault with an Excel 2007 workbook (xlsm)
connecting to a Access 2007 (accdb) database.

The connection string I'm using is

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & gconTargetDbase & ";Jet
OLEDB:Database Password=" & gconPass & ";"

where gconTargetDbase is the database path and name
and gconPass is the password for the database.

This code has been working for the past two years, yet the last few weeks
I'm experiencing the following error message on an intermittent basis.

Run-time error '-2147418113 (8000ffff)':
Catastrophic Error

Now this connection string sometimes works, but more often than not is failing

The Operating System is
XP Professional SP3

Excel 2007 (12.06514.5000) SP2 MSO (12.0.6425.1000)

The antivirus is

Symantec Endpoint Protection v. 11.0.4014.26

thanks for any pointers.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to a protected workbook? 3
Exporting data with vba from Excel to an Access 2007 db with password 8
export excel data to access table using ADO 0
ADO - Access to Excel 5
Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine 0
Excel 2007 connection via oledbconnection 2
ADO connection to Excel 2007 *.xlsx files? 8
ADO from .xls to .xlsm file - "Unrecognized database format" error 4

Top