Thank you! That worked very well.

"Jan Karel Pieterse" wrote:

Hi Frank,

The location of the Access Database has been changed to a new
folder. Is there a way in Excel to change the link location (address)
without having to delete and rebuild the links? Somplace where I can type in
the new location for the source data?

Try my query manager addin:

www.jkp-ads.com/download.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

.