Unanswered: Linked tabels with FE and BE are to slow???
I work with a big access2000 database. I use linked tables from Front-end to back-end. The FE and BE are linked up with a UNC-path. The FE is on a workstation and the BE is on the server.
When I want to open a report with lots of calculations then it opens 10 slower if I want to open it over the UNC-path. Are there any options so that it will work faster? I know that it will be much faster with stored procedures and SQL-server but I don't have it at this time. This is a real annoying problem because it costs a lot of time to wait on the reports.