N
Neil Holden
I have an Excel sheet linked to a Access Live Database which pulls
information into Excel. The access database as recently been converted to
SQL so of course now I've had to change all the Queries in Excel linked to
SQL which I've done no problem. All the queries have now been changed.
The problem now is:
When I open the excel file it is still looking for the Access database which
the error message:
"ODBC Microsoft Access Driver Login Failed" If I click ok to that message
the Datasource dialog box appears with MS Access Database. I have gone
through the entire Excel sheet and can't find any link between the old
database!!
Please help this is driving me crazy!!! Thankyou.
information into Excel. The access database as recently been converted to
SQL so of course now I've had to change all the Queries in Excel linked to
SQL which I've done no problem. All the queries have now been changed.
The problem now is:
When I open the excel file it is still looking for the Access database which
the error message:
"ODBC Microsoft Access Driver Login Failed" If I click ok to that message
the Datasource dialog box appears with MS Access Database. I have gone
through the entire Excel sheet and can't find any link between the old
database!!
Please help this is driving me crazy!!! Thankyou.