I have an Access database set up with linked tables that connect to tables in another access-based database. No changes are made to the original data via these tables, they are only querried. We are having performance problems with the original database (it is used via a proprietary software application. Could our linked tables be contributing to this?

They might be causing a problem. Why not just pull the data you need when you need it instead of having persistent connections to the live data?


mmcdonal

I was afraid that might be the answer - I haven't ever set up anything along those lines. Is there an easy way to do so within Access?