Update Query in Access not working

I had this question after viewing Update query does not work - Access 2016.

I run an update query and nothing happens.  No error, nothing.  The field, YrData, is numeric long integer and I am trying to fill in all rows with 2017.  I even tried changing it to short text and running, still nothing (See attached jpg)
Update-Query.jpg
pmpataneAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
There is nothing obviously wrong.  Where is the table?  is it Jet/ACE?  Is it in the FE or the BE?  If you open the table in data sheet view, can you update any columns?
0
Gustav BrockCIOCommented:
You are probably updating or viewing another table than what you think.
0
Dale FyeOwner, Developing Solutions LLCCommented:
It may be that you somehow turned off the SetWarnings indicator. In the VBE editor enter:

docmd.SetWarnings True

Now when you run the query, you should get some sort of message.

Then, you might try:

SELECT * FROM [yourTableName]

Any chance that what you think is a table is actually a query?
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

John TsioumprisSoftware & Systems EngineerCommented:
I am thinking that maybe you are having the wrong datatype in your table and you are trying to commit something that shouldn't happen...i suspect that you are using lookups in your table along with some kind of validation and mapping
So if your datatype is Number (byte) and you are trying to update with the value of 2017 it will fail because byte goes from 0 to 255...on the other hand you are seeing 2017 when you open the table...but probably there is a lookup and you are looking at the end value as there should be a table probably called Years or tblYears or something similar and it has a mapping something like
  1 ----> 2000
10 ---> 2010
17 -- > 2017
18 --> 2018
0
pmpataneAuthor Commented:
Hi all,,my apologies for the delay, I was pulled into another project. I am going to check the Set Warnings answer by Dale on Monday.  But this is just a basic table and I have gone into Create Query Design view, created an Update query on just this one field which is Number, Long Integer and I can type into the field 2017 but I obviously don't want to do that for the 1,000+ records
0
pmpataneAuthor Commented:
Nothing worked on the database to get the Update Query to do something, anything.  I then started a blank database, imported all the objects from the offending database, and everything works fine now.  Must be some corruption in the old database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.