Results 1 to 6 of 6
  1. #1
    lookingforK is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    31

    Question 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".

    Code:
     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?

    Thanks in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Never encountered that error.

    Why are you updating "Mike" to "John"? Do you have a table of employees (managers)? Just save EmployeeID in StoreList instead of names.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    lookingforK is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    31
    Thank you June7.

    ... because sometimes several store managers are replaced by other guys.

    The change freq is small and less than 5 / year, so I don't use the lookup table ...

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You save the full name ("Mike Jones" or "Jones, Mike") in a single field?

    Sorry, can't see anything wrong with update query and don't know why the error. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    lookingforK is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    31
    Thank you June7

    Yes, I save the full name like "Mike Jones".

    It is weird because it works well with MS Access 2007, but not for MS Access 2010 ...

    I tried other DBs upgrade from 2007 version to 2010 version, and they are good.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Did you test on other computers running 2010? That's what I could do if you provide db.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-24-2013, 07:12 AM
  2. Replies: 13
    Last Post: 12-05-2011, 05:10 AM
  3. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  4. StrComp causing "Invalid use of Null" error
    By sephiroth2906 in forum Programming
    Replies: 5
    Last Post: 09-15-2011, 07:06 PM
  5. Update query from form "invalid use of null"
    By Lady_Jane in forum Programming
    Replies: 4
    Last Post: 08-16-2011, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums