Prev: Protecting macros
Next: Savecopy and saveas locking up excel
From: Paul Faulkner on 25 Mar 2010 06:39
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
 | 
Pages: 1
Prev: Protecting macros
Next: Savecopy and saveas locking up excel