Improving Linked Table Performance

When you view data in a linked table, Access has to retrieve records from another file, which can slow down your application. Fortunately, there are a few simple guidelines you can follow to improve the performance of linked tables:

• Limit the number of records that you view by using filters and queries.
• Don't move up and down the page unnecessarily in a datasheet.
• Don't jump to the last record in a large table unless it's necessary.
• If you just need a form for data entry, set your form's DataEntry property to Yes to avoid loading existing records into memory.

Access Index

Main Index