7 Ways to Speed Up Microsoft Access Forms
... are not saving the form and it will close faster. 5. Keep lookup tables local When working in a networked environment it is common practice to split the database so that tables are stored on the network in one database. The client pc then has a database containing the other MS Access objects such as forms, queries etc. This database connects to the tables in the network database. If you are using lookup tables it is better to keep these on the client pc though because these tables are never to be updated. The local form then does not need to pull ... type to be 'Snapshot'. 7. Try to avoid performing calculations on a network A networked database should not contain calculations, especially in queries. To improve performance, first retrieve any data you need and then make sure any calculations are performed in the local database. Conclusion It is vital our Microsoft Access forms load and close quickly. Forms can become quite large at times and speed is of paramount importance. Even though we now have faster computers we should still aim to optimize our databases for optimum performance.
Tags: microsoft access forms | microsoft access | ms access | microsoft access training |
Tags: microsoft access forms | microsoft access | ms access | microsoft access training |