Cannot set AccessRecords. . .

Posted on 2006-05-16
Medium Priority
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
  • 2
  • 2
LVL 34

Expert Comment

ID: 16697770
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

ID: 16704931
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

Sancler earned 750 total points
ID: 16707824
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

ID: 16722728
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.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
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…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month16 days, 4 hours left to enroll

850 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