What to do if DLookup is Slow in your Access DB

In this Microsoft Access tutorial I'm going to teach you a few things to try to speed up lookups (DLookup, DSum, DCount, etc.) in your Microsoft Access database

Lucas from Chino Hills, California (a Platinum Member) asks: I don't know why one of my forms is loading so slowly. It's basically my customer list, but I need to look up their sales rep from the employee table based on their state. The form ran fine before I added the DLookup, but I really want that information on there. What should I do?

Prerequisites

• DLookup: https://599cd.com/DLookup

Links

• Concatenation: https://599cd.com/Concat
• Double Double Quotes: https://599cd.com/DoubleDouble
• DDQ Not SQ: https://599cd.com/DDQnotSQ
• Outer Joins: https://599cd.com/OuterJoin
• Multiple Joins: https://599cd.com/MultipleJoins

Recommended Courses

• DLookup in Access Expert 10: https://599cd.com/ACX10
• Relationships in Access Expert 1: https://599cd.com/ACX1
• Relationships Seminar: https://599cd.com/RelationshipSeminar

Checklist

• Indexing
• Network (cache locally)
• Does form load fast without DLookup
• Multiple records (reports, continuous forms, queries)
• Avoid in VBA loops (use recordsets)

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, DLookup too slow, DLookup slow results, DLookup running very slowly, Need something faster than DLookup, domain aggregate functions, dlookup, dsum, dcount, dmax, dmin, dlookup in query