Linked tables running slow over network

[borgia]

Hi

I have a couple of acces databases running on a peer to peer network (database A and B, which are housed on PC1). The database B has a link to a Customer table in database A. This was running fine until another user on the peer to peer network wanted to use database B on their pc (PC2). I had to change the the file location of the linked table to show it's location on the network so PC2 could open it. Unfortunatley this greatly slowed the operation of the database B on both machines.
If anyone has made it this far - Is there any way round this?

Regards

David

 

[RuralGuy]

Perhaps some of Tony Toews tips will help. Microsoft Access Performance FAQ

 

[borgia]

Thanks for the link. Very useful.

 

[RuralGuy]

You're welcome! Tony knows his stuff!