Unanswered: Problem Linking to Network files/tables
At my current office, I'm having trouble linking from a mdb file on our network to other tables in mdb files on the same network. I've designed the db and it worked fine but then when coworkers used it from their PCs (similar rights as mine) they got an error regarding linked tables' file paths. I think the problem is link shows G:\... and I want to us the full path \\xys\ss\sss. I found "G" path in MSysObjects table Database field but I can't edit it to include correct (physical or logical, I can never remember) path.
If I go onto someoneelse's PC and relink these tables, they work fine for that user, but then not my PC. I think it's the way this company's horrible network is engineered (my drive letters change constantly for the SAME file path!)
The linked table manager does let me update it either. Any advice regarding how to relink or revise these tables. Please help!