Queries freezing up?

[Guest]

I have a minor problem, which is that I have a set of queries that for some
reason just seem to freeze up every time I run them. One query I'm having a
problem with is a simple Append query that appends ~4600 records and has no
criteria. When I run it, it seems to go for a few seconds, and then the
progress bar at the bottom just stops and my mouse cursor changes from an
hourglass back to a pointer.

As it's a fairly simple query, I can't imagine that it would take much more
than a minute or so to execute, however even if I wait for 5 minutes or so it
still doesn't seem to do much.

Has anyone else experienced this problem? Any help would be appreciated.

Thanks,

Chris

 

[Guest]

What kind of network? Wouldn't happen to be Novell would it? There use to be
some issues with Novell and Access.

How many indexes are on the table where you are trying to append nearly 5K
records. If someone went overboard and created a lot of indexes, an append
would take longer.

While certainly not ideal, you could split the append into two or more
operations. Use criteria on a field that would select about half the records
and use is as the first append query then do the second batch of records.

 

[Guest]

I figured out what the problem was. Apparently, the name of the table I was
appending to was part of the FROM clause, as well as the table I was
appending from. I deleted the name of the table I was appending to in the
clause and the query now works fine.

Thanks,

Chris