Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Please Help!! Field cannot be updated. (Error 3164)

Discussion in 'Information Technology' started by StuJol, Jul 28, 2006.

  1. StuJol

    StuJol
    Expand Collapse
    Guest

    i have a database that has been working for for over a year.

    i have a form that is linked to a qry. when the form opens it shows a blank
    record. when you type in data in any of the fields you get a msgbox "Field
    cannot be updated". on clicking OK this message box appears another 4 times
    then the record can be edited as if the message boxes dint appear.

    whats more strange is that i have approx 40 different backups of this
    database. Saved as i was developing it. All these databases have the same
    fault but didnt yesterday.

    i dont know whats going on? has this happened to anyone before or can anyone
    help??? please.
     
  2. Loading...

    Similar Threads Forum Date
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Please help Questions and Answers Nov 1, 2013
    Please Help! What is the Name of the Narrator/Raagi? Gurbani Download Oct 16, 2012
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Help Please :/ Relationships Apr 19, 2011

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 14 Jul 2006 14:30:01 -0700, StuJol
    <StuJol@discussions.microsoft.com> wrote:

    >i have a database that has been working for for over a year.
    >
    >i have a form that is linked to a qry. when the form opens it shows a blank
    >record. when you type in data in any of the fields you get a msgbox "Field
    >cannot be updated". on clicking OK this message box appears another 4 times
    >then the record can be edited as if the message boxes dint appear.
    >
    >whats more strange is that i have approx 40 different backups of this
    >database. Saved as i was developing it. All these databases have the same
    >fault but didnt yesterday.
    >
    >i dont know whats going on? has this happened to anyone before or can anyone
    >help??? please.
    >


    Try Tools... Compact and Repair; and then if that doesn't work, try
    rebuilding the Query upon which the form is based.

    John W. Vinson[MVP]
     
  4. DraconXanathos

    DraconXanathos
    Expand Collapse
    SPNer

    Joined:
    Aug 8, 2012
    Messages:
    1
    Likes Received:
    0
    It's 2012 and I have this same issue with my Access 2010. No solution was ever found?

    Error pops up 3 to 4 times and then you can create a record. This happens only at the form level (in a combo box). No issue when adding record directly on the query or table.
     

Share This Page