The problem is with Access. the databases are not backwards compatiable. If
your have a 2003 database you must use 2003 Access. If you have a 2007
Access you must first update your database to 2007 before you can use office
2007 and then 2003 won't work with the database.


Databases and Excel Spreadsheets have version number that you son't see. Yo
have to copy theh 2003 worksheet into a 2007 workbook to upgrade the
worksheet. Yo may also need to change your reference libraries in the excel
VBA to 12.0 libraries. the references are in the VBA menu Tools -
References. 2003 libraries are 11.0 and 2007 libraries are 12.0.


"June7" wrote:

I have a workbook with VBA code originally built under Excel 2003 and an
Access project originally in 2003. I converted both to 2007 but the workbook
will not recognize the Access 2007 database. Workbook is not linked to
tables. I pull in records with an SQL query. I changed the connection
string
to reflect the different file extension but nothing else. Any idea what I
need to do to get these files compatible?