Additions/corrections to data dont "take"

[DogmaDot]

I have a query in a DB that doesn't work right any more. Up till now, when
I add data and exit the query, the changes to the fields were automatically
saved as usual. I've checked the properties in the query and the
"inconsistent updates" is specified. The query consists only of tables.

Have I possibly reset something by mistake?

 

[John W. Vinson]

I have a query in a DB that doesn't work right any more. Up till now, when
I add data and exit the query, the changes to the fields were automatically
saved as usual. I've checked the properties in the query and the
"inconsistent updates" is specified. The query consists only of tables.

Have I possibly reset something by mistake?

what happens when you try to edit the query? Does it have a blank row at the
bottom with the *> new record icon? Might you have unintantionally set
SetWarnings No in a macro or code (suppressing warning messages)?

Perhaps you could post the SQL view of the query.

 

[a a r o n . k e m p f]

uh, Jet randomly loses data
if you care enough to build a database-- use a database with a
future-- like SQL Server for example

Jet is too buggy to use in the real world, sorry, but you got suckered
into a crap database platform!