link tables - choose when to link

[philfer]

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

[OBP]

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.

[OBP]

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


in the VBA Editor's Help.