Hi,
I recently had an Access database in Access 2007 format. I use an Excel spreadsheet connected to queries in the database to do pivots etc. I recently updated the database to Access 2010 SP2 format.
Now if I try to connect an Excel workbook to a query in the database, I can't see any queries or tables in the "Select Tables" window that appears after selecting the database.
Does anyone know why I would have this problem? I can't find anything on-line....
Thanks in advance....
I recently had an Access database in Access 2007 format. I use an Excel spreadsheet connected to queries in the database to do pivots etc. I recently updated the database to Access 2010 SP2 format.
Now if I try to connect an Excel workbook to a query in the database, I can't see any queries or tables in the "Select Tables" window that appears after selecting the database.
Does anyone know why I would have this problem? I can't find anything on-line....
Thanks in advance....