Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    173

    Unanswered: Cannot Add or Update Records After Upsizing

    I used the upsizing wizard to upsize a MS Access 2003 database to SQL Server 2000

    It all went well - and in table view - I can add/update records

    using a form - it just hangs - and the status bar reads Calculating.....
    the form is a simple form with a few fields, and an add and save button
    the table has a unique index and primary key

    prior to upsizing - it all worked in Access

    any help is appreciated..

    AB

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Need more details about the form. What code does it have behind the scenes? What calculated controls does it have?

    If it's a really simple form, have you tried re-creating it?
    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

  3. #3
    Join Date
    Aug 2004
    Posts
    173

    Form Recreated - found what causes issue...

    Quote Originally Posted by StarTrekker
    Need more details about the form. What code does it have behind the scenes? What calculated controls does it have?

    If it's a really simple form, have you tried re-creating it?



    I recreated a simple form with only a few fields - and it works when opened normally... just by dbl-clicking...

    the issue of hanging after updates occurs when opening the form to view specific data using the code below from a search form..

    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "frmAddress_Main"
    stLinkCriteria = "[AddressID]=" & Me![AddressID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    when I open the form this way - filtered, then I cannot update or add a record?

    I tried opening it bookmarked and it does the same thing?

    Again - this worked in Access - but does not since upsizing..

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Personally, I'd use

    DoCmd.OpenForm "frmAddress_Main", , , "[AddressID]=" & Me![AddressID]

    Rather than 5 lines of code.

    But that's another story.

    What is the form's Record Source? I've run into similar problems with upsizing and the solution has always been the underlying record source is that of a table rather than an SQL statement.
    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
  •