Access queries over Peer to Peer network

[kevink]

When I try and run a query over a peer to peer network, none of the fields appear in the query and Access throws up an error that it is looking for the fields in C:\My Documents....&nbsp;&nbsp;<br><br>How can I overcome this problem?&nbsp;&nbsp;(The query runs fine on the machine on which the database resides).<br><br>Thanks,<br><br>Kevin

 

[JimHorton]

kevin,<br>It sounds like you need to check the attachment string.&nbsp;&nbsp;You may need to reattach the tables on the machine that's connecting to the db on the peer.<br>--Jim

 

[kevink]

Jim,<br>What do you mean by the attachment string? <br>Thanks,<br>Kevin

 

[Jonathan]

When you attach tables to a database, Access stores the location of the MDB containing the tables, along with some other info, in the attachment string.&nbsp;&nbsp;Basically, it sounds like you need to open the database on one of the other machines and then run the Linked Tables Manager add in to update the links.&nbsp;&nbsp;If the add in is not avaiable, just delete all the tables and reattach manually.<br><br>Jonathan