So I run a bunch of stuff in an access database with a heap of linked tables, and suddenly the other day whenever I include anything with a certain table it slows down considerably and slows down the network too. If I take out that table it runs at a normal speed. If I run it through SQL with the offending table it's incredibly slow.
I've refreshed the links and re-linked the table which makes no difference. If I put a local table with the same data it runs but still extremely slow. The same linked tables in another database are fine.
Any ideas? If I've left out any info let me know.
