[AccessD] Access 2007 FE/BE speed

Access 2007 is inherently slow on a network configured using FE/BE scenario.

I have scoured several websites and spent a lot of hours, to see if A2007
can be modified to speed it up.

Several "tips" were obscure on the sites and might only be mentioned in
passing. 

Here is what I've found:

1)  ensure there is a persistent connection to the BE.  Code can be found on
the FMS, Inc. site.

2) Ensure the BE location is in a "Trusted Location" in the FE.

3) Change record-level locking.  I set the following: 

      OLE/DDE timeout: 30 

      Refresh interval: 30

      Number of update retries: 2

      ODBC refresh interval: 120

      Update retry interval: 250

4) Turn off unused user interface features such as: Show animations and Show
Smart Tags on Datasheets

 

In my somewhat limited test, my FE runs almost as fast as an integrated
file. I know it's running little slower, but I can barely see the difference
- I can live with it.  The biggest improvement came when I did 2 and 3
above.  I still haven't done or tested number 1 above.

 

Other items that are recommended are:  

     change the default open mode:  Exclusive

     default record locking:  Edited Record.  

However, I don't think these would work with a shared BE.  I don't think
there is a way to make these different for two separate files.

 

Do you have any other ideas or words of wisdom or comments?

Thanks,

Jim