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?