0

I have an Access database and an Excel file with some charts & pivots linked to it, and I want to put them on a USB stick so anyone can update and view the data.

I have some VBA in the Access file which rewrites the Excel connection strings to the queries, and this works OK.

Everything runs OK on my machine, but when I give it to someone else, they are able to view the database OK, but when trying to Refresh All connections in Excel, they get an error message showing the file path where I had initially saved the file on my C drive.

I have taken out every reference to this path I can see. Is there somewhere else in Excel / MS Query I need to update?

Erik A
  • 31,639
  • 12
  • 42
  • 67
steviemac2000
  • 35
  • 5

1 Answers1

0

I figured out what was going wrong.

There were some linked tables in the Access database and the path references were not being updated. I wrote some VBA to update these linked locations using CurrentProject.path as a starting reference.

steviemac2000
  • 35
  • 5