Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    Why Are There Different Versions Of Bhai Nand Lal's Rehitnama? Please Help Clarify Questions and Answers Mar 7, 2017
    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

  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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page