Results 1 to 2 of 2
  1. #1
    botts121 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    19

    This Recordset Is Not Updateable

    Ok, I have two tables on a MySQL backend linked through ODBC and a form and a query on the frontend (ACCESS). The query is set up to show both tables, linked through the phone numbers on each table and then the fields added to the query so they link on the form.

    I have done this multiple times with other forms, queries and tables in the same database and all have worked correctly. But for some reason this form this time, while setting it up the same way, when I open the form, and go to edit the data on the form, which goes through the query and then to the linked ODBC tables, I can't edit anything on the form and it says "This Recordset Is Not Updateable" in the lower left hand corner of ACCESS.

    Does anyone have any ideas with this problem?

    Thanks in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,914
    Maybe this link will help.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. The Recordset is not updatable
    By bullet_proof302 in forum Access
    Replies: 2
    Last Post: 11-07-2009, 12:13 PM
  2. select records in recordset
    By sksriharsha in forum Programming
    Replies: 3
    Last Post: 09-05-2009, 11:40 AM
  3. Query decided it didn't want to be updateable anymore
    By tylerthompson in forum Queries
    Replies: 0
    Last Post: 07-23-2009, 09:43 AM
  4. ADO.Recordset - Write
    By Marvin in forum Programming
    Replies: 0
    Last Post: 07-17-2009, 07:56 AM
  5. This record set is not updateable,
    By MFS in forum Forms
    Replies: 1
    Last Post: 03-24-2009, 08:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums