Amending info in linked excel table from network pc

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top