[John Rogers]

The app part of the Access database has to check across the network every time it wants to do something. Access is NOT meant to be a network based database system, but a beginning system to get you started and then have you move to DB2, SQL Server or the big guy, Oracle.

With a form or screen there is code such as PL/SQL behind them and with Access the code has to load every time you do something such as clicking a control button to run a report. Also remember that running the app part of Access or the forms, they are interpreted as you run them so memory has to be rebuilt. In Oracle the code is in the server memory, cached and as long as each instance of the command is exactly the same, the cached code will be used so it is much faster.