S Scott Nov 12, 2006 #1 When I construct a database for multi-users on file server, should I use index or sort to give the best performance. Thanks, 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
G Guest Nov 12, 2006 #2 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 __________________________________________
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 __________________________________________
