Access 2003 vs 2007 2

[hefly]

I have an Access 2003 database with about 800,000 records. It takes about 2 seconds to run a query. That same database in Access 2007 takes between 60 and 80 seconds to run the same query.

Is this normal?

Hefly

 

[Darrylles]

Hi,

No idea from usage, but, have the table indexes been reproduced in the conversion?

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[missinglinq]

This is a very commonly reported problem with 2007, especially with a back end accessed thru a network. I'm assuming that with 800,000 records that this is probably your situation.

Make sure you have all of the service packs/hotfixes installed for 2007. Many of these slowness problems are reportedly fixed by these.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[hefly]

The tables were imported into 2007 and the application is not split between front end and back end. The tables are set up as indexed. Is there any other procedure necesary other than to declare them indexed?

Thanks.

Hefly

 

[alvechurchdata]

I'm not sure what you mean by saying that the table is indexed. Indexes apply to particular fields in the table rather than to the table itself.

You don't need to index every field in the table. Go into the Table Designer and index those fields that are used in the query. You'll need to index every field that is used to select, sort, or join records.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ajrimmer]

Have you installed SP2? I had some speed issues with Access 2007 which improved dramatically with SP2.