So far we were using Access 97.

We query data in a VBA procedure. This procedure puts together a SQL
string and opens a recordset with it.
We use only DAO libary.

Now we changed from NT opereating system to XP.
After converting the database to Access 2003 this query is about 10 to
20 times slower.

Can somebody tell me a raeson for that? Thanks a lot.

Beat Scheidiger

I'd pop it back into the 97 and try the 97 version on your XP system. Could
be the difference between NT and XP. Gotta find out which is broken
first...

hang in
ron

"Beat Scheidiger" <beat.scheidiger (AT) swisscom (DOT) com> wrote

Oh, and one more thought. Starting with Access 2000 I think, there was a
really neat thing called Name AutoCorrect. Was supposed to automatically
track all your table/field name changes and automatically change any
reference to that name change. Only thing is, it either doesn't work, or it
slows everything down SO MUCH that it's unbearable. Common suggestion with
a speed problem is to de-select that feature (it's wise to do so even
without a speed problem).

I don't know where it is in 2003, but in 2000 it's in Tools/Options/General.
Deselect everything associated with Name AutoCorrect and try your query, see
how it goes.

hang in
ron

"Beat Scheidiger" <beat.scheidiger (AT) swisscom (DOT) com> wrote