Avatar of Dale Logan
Dale Logan
Flag for United States of America

asked on 

Set linked table path using VBA


I have an Access database that is published to a SharePoint site. I have a linked table that is currently pointing to a CSV file on my local machine. I run a daily process using that table. The CSV file is also on the client's in-house server and is updated nightly. I would like to allow the client to run the daily process. However, I can't figure out how to change the linked table to be using their copy of the file. Any help would be greatly appreciated.

Thanks, Dale
Microsoft AccessMicrosoft SharePoint

Avatar of undefined
Last Comment

8/22/2022 - Mon