Recent content by Bobby Burns

Thanks Roy, that works fine now. Thanks Bob too for your replies.

What exactly do you mean by 'do I have all of my updates?

I'm using Windows XP Professional and yes, I have a reference set up ok to ActiveX 2.8.

Hi there, I am trying to connect to an Access 2007 database (.accdb ext) from an Excel 2007 workbook (.xlsm ext) using ADO and the following connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDatabaseName.accdb;" When I try and connect, I get the error message "Unrecognised...