View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Holden Neil Holden is offline
external usenet poster
 
Posts: 163
Default ODBC Microsoft Access Driver Login Failed - Excel 2003

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.