O
Olaf NC
I created a pivottable in compatibility mode in Excel 2007 based on an
access file (also access 2000 format). The Access file is used to collect
data from a SQL server and combine the data.
Updating the pivottable is running smooth in Excel 2007.
If I open the Excel file on an Excel 2003 machine the pivottable can be
adjusted, but refreshing data gives an error
--> "ODBC connection to 'xxxxx' fails"
--> "Problems obtaining data"
If I open the Access file with the Excel/Access 2003 machine, the SQL data
is collected as it should be.
I tried to make a new pivottable in Excel 2003 on the Access database, but
this resulted in the same error.
Might this be a security setting in Access not allowing Excel to get Access
to update the SQL data?
The SQL server requests a username and password, this screen is not
displayed (might be a source of the problem?)
Who can help ????
Thanks in advance,
Olaf
access file (also access 2000 format). The Access file is used to collect
data from a SQL server and combine the data.
Updating the pivottable is running smooth in Excel 2007.
If I open the Excel file on an Excel 2003 machine the pivottable can be
adjusted, but refreshing data gives an error
--> "ODBC connection to 'xxxxx' fails"
--> "Problems obtaining data"
If I open the Access file with the Excel/Access 2003 machine, the SQL data
is collected as it should be.
I tried to make a new pivottable in Excel 2003 on the Access database, but
this resulted in the same error.
Might this be a security setting in Access not allowing Excel to get Access
to update the SQL data?
The SQL server requests a username and password, this screen is not
displayed (might be a source of the problem?)
Who can help ????
Thanks in advance,
Olaf