Linked table not found when accessing on another PC

[MCCDOM]

Hi There,

I have a database that uses the table of another database for the names so I don't get a mis-mash of names across databases but for some reason when I try to do anything in the database that requires the linked table I get an error "'N:\Database.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." Both databases are located in the same folder on a NAS device. You can open both databases fine on the secondary computer but get the issue when accessing the linked table however on my primary PC I don't get any issues accessing the same two databases.

Any suggestions as to why this might be please?

Kind regards,

Dom

 

[Lightwave]

Sounds to me as if the new computer doesn't have a network drive mapped to N.

How to map a drive in Windows 7

 

[Minty]

This is one reason you are better of using UNC paths - they don't need mapping on each machine.
\\YourFileShare\YourSharedFolder\database.accdb

 

[The_Doc_Man]

Using UNC pathing is preferable since other apps will also request use of mapped drives. First time you have a driver-letter conflict, you have to change every user of one of the conflicting apps. With UNC pathing, that never happens.

 

[MCCDOM]

Thanks all for your help. You were right in that the issue was the other computers mapped drive letter was different to the one on my main PC.