I can easily create an excel document that imports data from my access database.
In excel, when make the connection i point to the database using the network address of the database. for example, rather than just giving the local path for the access database, I give it a path using the local computer name. \\mr01monitoring\plant monitor\plant monitor.accdb
This works fine. I can open the excel file and the data imports correctly.
However, I create a shortcut to the excel file from another computer on the network and when I open the file from another computer, it is not able to connect to the access database.
If I try to create a new excel file on a network computer and point the connection to the access file that is on another network computer, it tells me there are no visible tables"
I have made this work before, but cant remember what had to be done. I believe that maybe the connection type was something other than "MS Access"