Index or sort

S

Scott

When I construct a database for multi-users on file server, should I use
index or sort to give the best performance.

Thanks,

Scott
 
T

Tom Wickerath

Hi Scott,

I can't say that I really understand your question...however, you should
consider indexing fields that you use to specify criteria or sort orders in
queries. Check out this document, especially the sections on Indexing and
using JET Show Plan:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Limit the Index to a Section Break range 0
Page numbering with Merged Document and IF statements 1
Resource Budget Cost - Tracking 0
How do I create a cookbook index from hard copies 7
index function in vba 4
Proper Indexing of Table Fields 8
Damaged Outlook 2010 file prevents indexing. Am I doing the right repairs? 0

Top