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