link tables - choose when to link

Hello,

Is there a way in Access to have a linked table but not have the link open all the time i.e. just to relink/refresh from the source when I decide

I know I could just import the table but its a big table!!!

The reason I ask is that an excel workbook also uses a connection to this file (a Dbase file) and when I am running queries in Access that use the linked table in excel it says the link is opened exclusively by another user i.e me!!!

Thanks for any help
Phil

Phil, what is wrong with having the table in the Access database?
It could then be linked to from Excel. Table size doesn't make much difference to loading times in Access.

See the
RefreshLink Method (DAO)@import url(/Office.css);RefreshLink Method


in the VBA Editor's Help.