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.

Can someone help me out here????

Thanks very much!!!!!!!