Query stops working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple update query that updates about a dozen fields in a table
with current info from another table. This is a simple straight forward query
that has worked fine in the past. Now all of a sudden it gets about 2/3 of
the ways thru and just stops. No error messages. No nothing. It just sits.
The tables are in the back-end of an application out on my server. All my
users are logged off. The query was originally created in Access 2000 and I
recently upgraded to 2003 but it has run in 2003 before. Anybody ever hear of
anything like this?

TIA
Lynne
 
Would it happen to be on a Novell network? There are issues with Novell and
Access.

Go to Tools, Options, General Tab and disable Name AutoCorrect. It's amazing
how many troubles this fixes.

You might try it with two queries. One that updates half the records and the
second the updates the rest. Not ideal but it might work.
 
Back
Top