Got pop-up error "Invalid Argument" when using UPDATE query in MS Access 2010

Thank you KARL DEWEY.

The manager field is not a 'lookup' field ...

Design the table. Inspect the Validation Rule properties for each field.

Also be sure there are no Data Macros defined.

Open the Relationship window. Inspect the relations to this table. Anything funny?

Did you compact the database?

Thank you Tom van Stiphout.

No Validation Rules.

No ralations to other tables.

Not compact the database.

It is weird because it works well with MS Access 2007.

But MS Access 2010 ...

Go to the VBA Window.

Go to DEBUG

Click COMPILE

Sometimes errors that it finds can actually be the cause of the problem when it doesn't seem logical.

If, when you do what I said up above, it gives you an error, it will highlight it.  Fix that error and then do the same thing again until you have no more errors.

Thank you boblarson.

I tried but no use.

Other databases don't have the similar problem...

Has anyone ever found a solution?  I am having the same error with a freshly created table.

I am having the same problem. It doesn't make sense - yet.

I've worked with MS access for about fifteen years and haven't seen this error in awhile - in Access 2003 it meant that the database was approaching critical size.

I'm getting this error when writing queries in databases that I've established that use data imported from another system.  The files are big (12k records) but not more than Access can typically handle.  Some of the fields have numeric/special character names (for instance, 1-Name, 2-Address, 3-Phone).

The database will work fine for awhile and then suddenly a perfectly straightforward update query will pop up with an "invalid argument" error.

In the same database, when I try to manipulate my imported tables, such as deleting a field and its data, or concatenating fields to a new field, I get strange errors that imply that the database is corrupt.  For instance, I will write a query using the table and get an error that the query can't find a field that never existed in the table (but that does exist in another table in the database.)

I suspect the two issues are related.

Compacting the database does not help.  Restarting access does not help. 

The VBA compile idea is interesting, but since there are no projects in the database, I don't know how (or whether) to do this.

The only thing so far that has worked is to copy the data into excel and re-import it into a new database.  Painful, since I've had to do that three times in as many weeks.  This time I'm going to try renaming the columns on the table that keeps breaking and see if that makes a difference.