Cannot set AccessRecords. . .

Posted on 2006-05-16
Last Modified: 2010-04-23
This question is worth 250 points. I would like the answer to be as specific as possible. Thanks!

I have a datagrid on one of my Forms, which shows the members of a department. The grid works fine, except for when it gives me an error, which occurs from time to time.  If I click on the grid repeatedly (trying to error test the Form) after numerous clicks on different fields, I get a message box that says:

      Error when committing the row to the original data store.                    < -- In the title bar

      Cannot set AccessRecords. Do you want to correct the value?              < -- In the message body

                  YES            NO

Why is this happening and how can I correct it?  

Any thoughts would be appreciated
Question by:Mr_Fulano
    LVL 34

    Expert Comment

    It looks very much as though the error messages that you report are coming from message boxes that you have coded - maybe in a Try ... Catch block.  To make any guess as to what is going wrong, we would really need to know what the system generated errors were saying, and the line/s of code to which they related.


    Author Comment

    No, the I did not code the message box that I described above. I have no message boxes that even come close to that kind of verbiage. The message is being generated by the system itself.
    LVL 34

    Accepted Solution

    Sorry.  I was searching on "Cannot set AccessRecords" as that seemed the most specific target, but it was too specific.  It seems that that part is a customisation of a more general error template.  A search on " Error when committing the row to the original data store" and/or "Do you want to correct the value" does produce results.  Unfortunately, they do not narrow the field down very much.

    I suggest you try this

    and see if any of the hits look like they might fit your situation.  The other thing I would suggest -  on the assumption that AccessRecords is a name somewhere within your app, rather than being a reference to records in MS Access - is looking at, and possibly putting Try ... Catch blocks round, code that references that name and hoping for a more specific pointer to where the error is occurring.  Or, if it seems more likely to you that AccessRecords is a reference to records in MS Access, it might be worth looking at any part of your code that attempts to save record/s to the db.


    Author Comment

    Sancler, thank you for the research you provided. I'm going to award you the points because of your efforts, which I do appreciate. I was not able to determine what exactly it was that causing the error, but I made a few changes based on the info you provided and made the error stop happening. Thanks again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now