Upgrade to Office 2003, queries don't work

[Guest]

There are several update queries in a db I am maintaining. They run when a
user enters data in 2 fields on a form and clicks a button.

The button runs 8 queries in succession, then opens a form to see the results.

Several of the queries are update queries.

In Office 2000, they worked fine. Now that they have upgraded to 2003 the
queries no longer work.

The first one runs slowly.
The second one gets a single bar of progress and does not come back. The
users say they have waited over an hour and gotten no progress.

I isolated the queries and found that three are causing the slowdown. Two
are update queries, the other is an append query.

The db is large (250 MB), and has thousands of records.

Any help would be apprecaited.

 

[Guest]

Seems to be a lot of this happening.

Both append and update queries can be slowed down by indexes. If you have
any unneeded indexes, dump them.

Conversely an index might help on the update queries. If you are only
updating certain records, try indexing on the fields with criteria in the
update query. First check to see if they aren't already indexed.

250 mb is rather large especially if it only has thousands of records. Make
a backup and do a Compace and Repair. That might speed things up.

 

[Guest]

'You da man', Jerry.

The db has tons of indexes. I removed many and the db had other issues.

Since I was working from a copy, I went back to the original and (after
copying again) removed only a few. Success.

Now I may have another problem with the db, but that seems to be a separate
issue.

I appreciate your (timely) help.

'wanna be' (gonna be)

'Outside of a dog, a man's best friend is a book,
and inside of a dog, it's too dark to read.'
- G. Marx