Amending info in linked excel table from network pc

[Guest]

I have linked an excel database and set up forms, queries etc which have been
working fine on main office pc. When I try to access this from a networked
office pc I can open the database but when I try to open the linked table it
says path is incorrect and will not allow me to access. I need to access and
amend table from more than one pc can anyone help?

 

[John Nurick]

This will happen if the path to the Excel workbook in the shared folder
is different on the two PCs.

One solution is to re-link the table when you install the database on a
new PC, using the Linked Table Manager. Another is to create the linked
table in the first place using a UNC name, e.g.

\\COMPUTERNAME\SHARENAME\Folder\Folder\File.xls

instead of

D:\Folder\Folder\File.xls

You also need to ensure that the other user has sufficient permissions
on the shared folder.

 

[Guest]

Many thanks for you quick response. All working now having used UNC Name.