philfer
04-24-2010, 02:20 AM
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
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