Updates in Access

Results 1 to 2 of 2

Thread: Updates in Access

  1. #1
    Join Date
    Dec 1969

    Default Updates in Access

    Hi Guys, I&#039;m trying to Update a Table in Access, and am getting the following error, can anyone tell me why?<BR><BR>"Opertation must use an UpdateAble Query"<BR><BR>Heres the SQL I&#039;m using<BR><BR>UPDATE MessageTbl SET ThreadID = (Select Max(PostID) from MessageTbl), ParentID = (Select Max(PostID) from MessageTbl) WHERE PostID = (Select Max(PostID) from MessageTbl)<BR><BR>Thanks in Advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Updates in Access

    The IUSR_[machinename] account needs write permissions in the directory where the database is.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts