-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules