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

[lookingforK]

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

Hi,

I am using a MS Access 2010 DB that was upgraded from MS Access 2007.

When I run a simple UPDATE query (e.g. as follows) that works fine in MS Access 2007 version, I get the pop-up error message "Invalid Argument".

UPDATE [Store List] SET [Store List].Manager = "John"
WHERE ((([Store List].Manager)="Mike"));

The database is well below the 2GB limit.

Another weird phenomenon is: when I manually change some values using copy-paste upon the table, the error "Invalid Argument" pops up too; if I ignore it and continue pasting the new values, the update can be done.

How to deal with this issue?:banghead:

Thanks in advance.

 

[SOS]

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

It may not be that query that is causing the problem. It may be something else. Go to the VB Window and to DEBUG > COMPILE and see if any errors show up. If so, fix and do it again until there are none. Sometimes the errors that Access reports have nothing to do with the actual problem.

 

[lookingforK]

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

Thank you SOS.

It looks like complicated ...

 

[JHB]

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

UPDATE [Store List] SET [Store List].Manager = "John" WHERE ((([Store List].Manager)="Mike"));

It could be the " double quarto try replacing them with a ' single quarto.
But when you say:

... when I manually change some values using copy-paste upon the table, the error "Invalid Argument" pops up too; if I ignore it and continue pasting the new values, the update can be done.

Then I would first try a Compact and Repair, then a reinstall of MS-Access 2010.

 

[SOS]

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

Thank you SOS.

It looks like complicated ...

It isn't complicated.

From the Ribbon

Click DATABASE TOOLS tab
Click Visual Basic
The VBA Window will open
Click DEBUG on the top menu
Click COMPILE from that menu

I would NOT do an reinstall like JHB said until you have at least tried this.

 

[JHB]

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

I would NOT do an reinstall like JHB said until you have at least tried this.

I do agree.