Primary Key Should be One Field and Numeric This allows your database application to quickly locate specific records.Īdditionally, you cannot create secondary indexes on a table's fields unless that table has a Primary Key. Read our paper on Data Normalization Fundamentals for more detail.Įvery table in your database should have a primary key. Remember that time is also a dimension and you may need Normalize your data so the same data is stored only in one place.

Data Access Objects (DAO) Programming Tips.Your specific application running on your specific hardware. You should evaluate each tip as it applies to Some tips may make things run faster on your system, while others degrade performance. Some of the tips may contradict each other but they are offered because bottlenecks differ in each situation. This paper outlines specific performance tips you can use to improve the speed of your Microsoft Access applications. Over 100 Tips for Faster Microsoft Access Databases Microsoft Access Performance Tips to Speed up Your Access Databases Provided by Dan Haught, Executive Vice President, and Luke Chung, President of FMS

How to change odbc timeout in access 97