Query won't run but copy will

  • Thread starter Thread starter John
  • Start date Start date
J

John

Has anyone ever seen this problem before?

I have a simple update query (that has been running daily
for months with no changes or problems). Now it's
returning error message "The field is too small to accept
the amount of data you attempted to add". But- when I copy
the query and run the new query it works...what's up with
that?

I'm 120% sure that none of the table fields the query uses
has been changed recently. Using Access 97.
 
John,

My guess is your database needs a little maintenance. Make a new, blank
database and import all objects from the old one, and add all necessary
references in the VB window (if you added any other than the default ones in
the original). Then rename your old database to, say, OLD_databasename.mdb,
and the new one to the original name, and start using that one. What you've
got is a fresh, clean copy to work with. As long as you compact it
regularly, you stand a very good chance of not having this problem again.

By the way, you have not mentioned whether this is a multiuser database, and
if yes, whether you have split it and provided a separate copy of the FE for
each user. If the answers are yes and no, then whatever you do you'll keep
getting problems (ultimately risking losing the whole db) until you split it
and provide separate FEs for users.

HTH,
Nikos
 
Back
Top