Why when I open my database exclusively do my reports open in design view instantaneously, but when I open my db normally they take actual minutes to open???
You should not be opening a report in design that's in a front end connected to a shared back end. It's not a local db, it's a networked db with a local front end.
If you're the Administrator, make local copies of the tables and connect to that.
You should not be opening a report in design that's in a front end connected to a shared back end. It's not a local db, it's a networked db with a local front end.
If you're the Administrator, make local copies of the tables and connect to that.
If the FE is connected to a BE (even if some of the tables are local) it will still be slow. Disconnect from the BE and you will notice great improvement.
If the FE is connected to a BE (even if some of the tables are local) it will still be slow. Disconnect from the BE and you will notice great improvement.
If you're going to be needing some data in the BE for testing then you will need to make local copies. But I would imagine you have backups so you can use one of the backup copies. And yes, disconnect from the BE, but you can connect to a local BE.
I can use it to update existing links or to prompt for a new location of he linked tables, but there is no option to disconnect completely. I suppose I could move the back end temporarily (no one is currently using it) and then refresh the links and see what happens.
I just sorted the access objects into "Tables and Related View" then it had to update my links, then when I sorted by "All Access Objects" it would tell me which tables were linked and which were local. I just deleted all the linked tables at once since I won't be needing them.
