Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Weatherford TX (Between Fort Worth and Abilene)
    Posts
    57

    Question Unanswered: ADODB Recordset in Access 2007

    I have an MS Access 2003 database that has code in the open event of a form that sets the recordset to an adodb recordset.

    This is the code
    Code:
    Dim sql As String
    sql = "Select * from tblQuickenData"
    Dim RsClone As ADODB.Recordset
    Set RsClone = New ADODB.Recordset
    
    RsClone.Open sql, CurrentProject.AccessConnection, adOpenDynamic, adLockOptimistic
    
    Set Me.Recordset = RsClone
    When I open the form with MS Access 2003 the records are updatable...I can add, delete append. When I open the same form with MS Access 2007 the records are read only.

    Can someone tell me why this is and how to fix it? I have a lot of databases that I've developed using MS Access 2003 and I would really like to convert them. I've used Access for well over 10 years. There are a lot of great new things in Access 2007, but there are also a heck of a lot of things that don't seem to work.

    Thanks
    GEM

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    There are a lot of great new things in Access 2007, but there are also a heck of a lot of things that don't seem to work.
    It's the latter of that that troubles me. I have lots of 2003 applications, but I cringe every time a customer calls and says they want it converted to 2007 because they just [s]down[/s]upgraded.

    As for your problem, sorry, I tend to use DAO.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •