CODEWITHSUNDEEP
ms-access
John Smith
John Smith

Reputation: 12236

MS Access: Make tables

For larger tables, running a maketable can sometimes take tens of minutes. Is there any way to speed the process up? I'm only vaguely aware of indexes but I don't know if they are relevant here for maketable speedup.

Upvotes: 1

Views: 158

Answers (1)

Johnny Bones
Johnny Bones

Reputation: 8402

Indexes are used to speed up the joining of multiple tables. They won't help you build a table faster unless that table is being built from data pulled in by a query. If that's the case, it's the QUERY that's taking so long to build and you should definitely consider indexing the related tables.

Upvotes: 1

Related Questions