tag:blogger.com,1999:blog-8134759511126815909.post4953692090200592397..comments2023-08-20T04:10:01.095-04:00Comments on <a href="http://rogersaccessblog.blogspot.com/">Roger's Access Blog</a>: This Recordset Is Not Updateable. Why?Roger Carlsonhttp://www.blogger.com/profile/12265719129831415014noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-8134759511126815909.post-63704372836909506112017-11-13T04:56:40.221-05:002017-11-13T04:56:40.221-05:00Thank you Roger,
Your info about linked table from...Thank you Roger,<br />Your info about linked table from excel have helped me to understand why now we cannot update it anymore. That was a 'rich' feature.<br />Rgds<br />Karelypsilonhttps://www.blogger.com/profile/17237702968676013230noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-31489746986148084862016-10-10T00:11:07.994-04:002016-10-10T00:11:07.994-04:00Thanks!!..changed a field in one of the queries ta...Thanks!!..changed a field in one of the queries tables to Indexed (No Duplicates) and the problem was fixed. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-21180359450810021872016-02-01T12:14:53.572-05:002016-02-01T12:14:53.572-05:00Your note on using Dynaset (Inconsistent Updates) ...Your note on using Dynaset (Inconsistent Updates) for many-to-one-to-many relationships just saved my behind. Thanks!!!Ken Stuberhttps://www.blogger.com/profile/13867079562554625325noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-59289627547333746972014-09-22T02:13:38.364-04:002014-09-22T02:13:38.364-04:00thanks didnt have keys set for some of the subsida...thanks didnt have keys set for some of the subsidary tables linked to the main table. all fixedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-11514569974487371682014-02-28T19:12:52.126-05:002014-02-28T19:12:52.126-05:00Thanks Roger. I'm an untrained muddler and was...Thanks Roger. I'm an untrained muddler and was able to understand your clear explanations and resolve my problem. As Arnie says "I'll be back . . ."Anonymoushttps://www.blogger.com/profile/00725974044024433406noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-75132211675246657812014-01-27T17:52:05.879-05:002014-01-27T17:52:05.879-05:00Roger you're the man. After 4 years your still...Roger you're the man. After 4 years your still saving lives.<br />Your tip about Union queries are not updatable and single tables queries are always updatable made me change the union queries I had to simple Or concatenations and it worked like a charm.<br />Thanks a lot and God bless you. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-69813281223770490802013-06-22T01:31:30.201-04:002013-06-22T01:31:30.201-04:00Reason #5: It is based on a Query that includes a ...Reason #5: It is based on a Query that includes a linked ODBC table with no unique index. <br /><br />I did not include the Key field nor * in my select statement, only a few non-index fields.<br /><br />I can't thank you enough!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-71348676826938536112013-06-19T18:05:37.786-04:002013-06-19T18:05:37.786-04:00Flippin' fabulous! :)Flippin' fabulous! :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-88869232594828065742013-02-26T13:29:24.545-05:002013-02-26T13:29:24.545-05:00Thank you so much for putting this together - save...Thank you so much for putting this together - saved me HOURS of work. I appreciate it.Mike Donlinhttps://www.blogger.com/profile/05678795532997932826noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-59872835122048925052012-06-15T12:43:04.426-04:002012-06-15T12:43:04.426-04:00Excellent - extremely clear and solved my problem ...Excellent - extremely clear and solved my problem in under 2 minutes!Vivienne McLennannoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-11026265760482324902012-06-05T11:03:18.954-04:002012-06-05T11:03:18.954-04:00wow, great detail. this helped me out immensely.
...wow, great detail. this helped me out immensely.<br /><br />thanks man!<br />vicAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-29363136726285159472012-05-07T07:09:53.038-04:002012-05-07T07:09:53.038-04:00Hi Roger,
I hit this problem when re-pointing an ...Hi Roger,<br /><br />I hit this problem when re-pointing an Access 2010 client to point to Access native tables instead of the original SQL Server linked tables.<br /><br />Inconsistent updates was the solution.<br /><br />Many thanks,<br /><br />James.James Wollastonhttps://www.blogger.com/profile/03234926623166796222noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-82550838418940768872012-04-26T00:04:27.708-04:002012-04-26T00:04:27.708-04:00hey Roger
your excellent information keeps hel;pi...hey Roger<br /><br />your excellent information keeps hel;ping people like me<br /><br />thanks<br />Ken RAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-34819716404430449292012-02-22T16:03:53.991-05:002012-02-22T16:03:53.991-05:00Hey Roger,
Your comments and suggestions pointed ...Hey Roger,<br /><br />Your comments and suggestions pointed me to my solution. <br /><br />Thank You<br />Mike e.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-15127032519457371142012-01-31T23:33:59.174-05:002012-01-31T23:33:59.174-05:00Thanks for this! I had a query where I had hit the...Thanks for this! I had a query where I had hit the agregate (sum) button but did't realise. I had't selected anything to group on and so the result set wasn't being agregated at all and so I was really stumped what the cause was till I found your comprehensive list of what to look for! Works like a treat now!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-47033464903973971432012-01-08T18:17:44.472-05:002012-01-08T18:17:44.472-05:00Thanks for the help Roger,
Saving my query defs w...Thanks for the help Roger,<br /><br />Saving my query defs with, "Dynaset (Inconsistent Updates)" made all my recordsource querries start working and my forms are working again!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-82394956921698546512011-10-06T07:14:58.773-04:002011-10-06T07:14:58.773-04:00RE: Access 2010 and Nonupdateable queries.
I have...RE: Access 2010 and Nonupdateable queries.<br /><br />I have not experienced this myself, although I've seen rumblings around the internet about it. The first thing to try is to make sure both the front end and back end databases are in <a href="http://office.microsoft.com/en-us/excel-help/add-remove-or-modify-a-trusted-location-for-your-files-HA010354311.aspx" rel="nofollow">Trusted Locations</a>Roger Carlsonhttps://www.blogger.com/profile/12265719129831415014noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-14195808625254871552011-10-06T05:38:53.057-04:002011-10-06T05:38:53.057-04:00Really interested in an answer to this latest prob...Really interested in an answer to this latest problem - 2010 seems like a different animal in so many ways. Simple things like updateable select queries that were so easy before now seem so difficult to resolve.<br /><br />321jimkAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-60894398381431624812011-09-22T18:41:43.002-04:002011-09-22T18:41:43.002-04:00Roger, maybe you can help me. I am not an Access e...Roger, maybe you can help me. I am not an Access expert. I taught myself to use it by creating an educator database for all the teachers in my county. I have a schools table linked to a teachers table using a number unique to each school. This allows to enter new teachers by putting in their name, grade, and school ID number to do things like generate lists and labels. At the beginning of the school year, I update the database by going to my teachers query--which is naturally based on those linked tables--filter by school name, or by grade level, and then update the teacher's names. We upgraded to Access 2010 and now I can't update using anything using any of my queries. It's driving me to tears. I think perhaps the answer is in your blog post but I don't understand it well enough to track down the problem... without screwing things up even further. Isn't there a way to make all my queries updatable the way they were in previous versions of Access? I didn't change the design of anything but now my whole system of updating the database is defunct.R Collinsnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-62810832088170518942011-08-21T15:58:44.303-04:002011-08-21T15:58:44.303-04:00Hall of fame tip, Roger (Dynaset (Inconsistent Upd...Hall of fame tip, Roger (Dynaset (Inconsistent Updates)). I could have saved myself 30 minutes if I'd come here first! Many thanks! RichardRichardhttps://www.blogger.com/profile/02736506874692127293noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-4289768608269954142011-08-08T08:45:40.673-04:002011-08-08T08:45:40.673-04:00Thanks for posting this useful information. Settin...Thanks for posting this useful information. Setting the recordset to Dynaset(Inconsistent Updates) fixed my problem.glonoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-81419513838516005842011-06-30T17:08:56.352-04:002011-06-30T17:08:56.352-04:00Thank you very much. I changed the field from ind...Thank you very much. I changed the field from index Yes duplicates to Index No duplicates and was able to fix it. I had a work around that did a select statement on the other table and was taken about 1 minute to run, now it runs in under a 3 secondsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-68105733664525549412011-06-10T23:04:24.965-04:002011-06-10T23:04:24.965-04:00I've made a web database in Office 365 (Sharep...I've made a web database in Office 365 (Sharepoint Online). The web database in Access 2010 allows a form with a query that uses dynaset - inconsistent updates. After syncing the Access Db with Sharepoint, the form in Access 2010 can edit the data in the table but the form in Office 365 (Sharepoint Online) does not edit the table data.<br /><br />Any ideas.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-92220826049860482632011-05-31T17:43:37.119-04:002011-05-31T17:43:37.119-04:00Thank you for this post. The lack of a unique inde...Thank you for this post. The lack of a unique index on an ODBC table in our test environment was causing problems, and your explanation was clear and concise.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-88716107043197670382010-06-05T06:52:32.161-04:002010-06-05T06:52:32.161-04:00Roger, so many reasons for the recordset not being...Roger, so many reasons for the recordset not being updateable, I found out the hard way when moving from 2003 to Access 2007 in Win 7, that the reason was simply the Op system's folder permissions set to read only. Annoying! And why doesn't Microsoft follow through with some decent error info and help?Newdeptshttps://www.blogger.com/profile/17468622241801090415noreply@blogger.com