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

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