Comparing two tables, trying to source one table from online data source

[malamute20]

Hello,

I have a macro to compare a set of tables. Previously this macro was used by someone else in my workcenter to compare two tables stored on a shared drive. My management team wants to source one of the tables from an online data source.

Now, when I go into my macro and try to change the data source for the online file, it's calling for an import from (local excel file,) and when I change it to the URL for the file online, I get the error, "The file does not exist, or you do not have read access to the file." I definitely do have access to the file, I'm listed as one of the owners of the online folder.

Any thoughts on how I can work around this to achieve the desired results?

Thanks

 

[JHB]

Try first if you can get (direct) access to the online file, then you can change the macro later or create a new one.
Below is a link how you get access to the different data sources.
http://office.microsoft.com/en-us/access-help/import-or-link-data-and-objects-HP005187610.aspx