Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2008, 05:13 PM
Registered User
 
Join Date: May 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default improve vba access queries using indexes

Hi VBA guru's

I need to improve my VBA access application which has couple of queries joining different Tables, the main challenge I am having is that it decrease the speed of queries after creating indexes. I have no clue why it is happening and how i can check that Table is using my created Indexes.

Please let me know what else i can do.

you answer is greatly appreciated.

Jani
 
Old July 22nd, 2008, 07:06 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What indexes have you created?

Normally you would have one clustered index on a primary key field per table, and then a non clustered index on each of your look up fields.

How bad is your performance, and what types of queries are you trying to run where performance is an issue? Also, what is the application environment? Sometimes it is the environment and not the queries themselves that is the problem.


mmcdonal

Look it up at: http://wrox.books24x7.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to improve performance with VBA and Powerpoint ravan76 Excel VBA 0 June 10th, 2007 11:29 PM
Queries from VBA bl Access VBA 2 November 15th, 2006 06:27 PM
Modifying The Queries Dialog Box VBA code Ben Horne Access VBA 1 September 26th, 2006 04:22 PM
writing SQL queries in MS access,VBA NovieProgrammer Access VBA 2 April 2nd, 2005 07:15 PM
Access queries kathy stratton Access 10 February 1st, 2005 10:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.