View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dannyrblock dannyrblock is offline
external usenet poster
 
Posts: 7
Default Deleting MS JET OLE DB references in an Excel 2003 file

An Excel 2003 workbook contains multiple queries to an Access database.
While updating this from one year to the next (and one user to another), we
discovered that the previous user created new queries instead of connecting
to the previous ones already in Access. We've modified all the tabs to use
MS Query to link to the Access database, but when we click on the "Update
all" button, we get the MS JET OLE DB Initialization prompts for his
versions. Can his old ones be deleted? If so, where can we find them?
We've created a completely new database, and revised all the tabs in the
Excel workbook, but we still get the MS Jet OLE notice. I would rather not
start the entire workbook from scratch....

Any thoughts???

Dan