Results 1 to 2 of 2

Thread: Update Query

  1. #1
    Join Date
    Nov 2003
    Location
    Boston
    Posts
    8

    Unanswered: Update Query

    I have created an update query in MS Access database. It was working absoultely fine until yesterday. But from today, when I run the query,

    1. It updates the table with only on record, i.e all the 200 records in the table are replaced by one single reocrd , while the primary key value remains as it is.

    Could anybody pls suggest what is going wrong

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Update Query

    Originally posted by kajalaggarwal
    I have created an update query in MS Access database. It was working absoultely fine until yesterday. But from today, when I run the query,

    1. It updates the table with only on record, i.e all the 200 records in the table are replaced by one single reocrd , while the primary key value remains as it is.

    Could anybody pls suggest what is going wrong
    Think about what you have done to the database within the last day. I usually find it's something that I have done that I wouldn't have dreamed would affect anything.

    My 2 cents

    Gregg

Posting Permissions

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