I am attempting refresh a data table in Excel (2007) via a data connection to an ACCDB. The database and the original spread were built on someone's computer who previously used Office 2003. My computer was Office 2007 loaded day 1 when I began using it.
When I go to refresh the tables linked to the database, i get an error message "Unrecognized Database Format 'T:\My Documents\Database.accdb'. I notice when I go to add a database connection, the types of files it offers are only "mdb", not "accdb".
What could be my problem and how can I go about fixing it?
Please ask for additional details that would better describe my issue.