K
Keith
I have a database which has links to and from other databases and
spreadsheets. I have 4 linked tables from spreadsheets on a server which I
see as drive 'H' however I have colleagues in other parts of the country who
need to update this database from the linked spreadsheets who see this drive
as 'K', I have got round this problem with spreadsheets by using the UNC
address, however when I create a linked table in access I do not have the
choice to change the local address 'H/Sales/' etc to the UNC address, even
when going into 'change location' option. Has any one else had the same
problem and found a workaround.
Thanks in advance.
spreadsheets. I have 4 linked tables from spreadsheets on a server which I
see as drive 'H' however I have colleagues in other parts of the country who
need to update this database from the linked spreadsheets who see this drive
as 'K', I have got round this problem with spreadsheets by using the UNC
address, however when I create a linked table in access I do not have the
choice to change the local address 'H/Sales/' etc to the UNC address, even
when going into 'change location' option. Has any one else had the same
problem and found a workaround.
Thanks in advance.