Access Data Base linked to Excel needs to be moved

[Joseph K]

I have an Excel workbook that is linked to an Access data base.

User's enter data into Access and Managers use the Excel spreadsheet to
filter the information.

We need to move both the data base and the workbook to another location on
our network, but it looks like the person that created all this stuff 3
years ago (and who is no longer with the company) hard coded the link
between Access and Excel.

Is there any way to change the path without re-creating everything?

I can use either Excel/Access XP or 2003

Thanks in advance for any help

Joseph K

 

[Guest]

I think you'll need to provide a bit more information....

How does Excel pull the data from MS Access?
Pivot Tables? a data list populated by MS Query?
Is the application controlled by VBA?

***********
Regards,
Ron

XL2002, WinXP