Invalid Argument on update query in v2010

[DropDeadDavey]

Hi,

I have a simple update query that worked fine in access 2007 version but with the 2010 version it now fails with "invalid Argument". The database is well below the 2GB limit

I have re-run the same query using 2007 version and it still works ok.

In 2010 version the query fails when including certain fields to be updated, if you exclude these fields it works fine.

Thanks in advance

[TheShabz]

Posting the SQL would be helpful.

[DropDeadDavey]

Thanks for your response but I have now solved the issue,

For reference, 2010 does not cope with linking tables where the link field has a different name in each table.