Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting MS JET OLE DB references in an Excel 2003 file
Hi all. Just wanted to inform everyone that I solved my own problem by going
to Insert/Name/Define and deleting all the extraneous references. Now the Refresh All command works perfectly! Hope this helps someone else! Dan "dannyrblock" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003- multiple references | Excel Discussion (Misc queries) | |||
Deleting Rows in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I convert a Excel 2003 file into a Word 2003 file (table)? | Excel Discussion (Misc queries) | |||
deleting worksheet and associated references | Excel Discussion (Misc queries) | |||
Deleting Names in Excel 2003 | Excel Discussion (Misc queries) |