Post reply

@@Identity returning Null

  • June 17, 2004 at 9:52 pm

    #510949

    Thanks folks for your help.  This is a great forum.  I am learning a lot.

    I have my application working again.  I came across an article on steps to take before upsizing an Access database. 

    Step 1 is to remove any random autonumber field.  I had not done that, and even when I changed the field properties in SQLServer it would not work.  So I went back to Access and changed the primary key to an int.  After upsizing, I made the primary key an Identity.

  • July 1, 2004 at 9:38 am

    #512971

    @@Identity is not a safe option so try SCOPE_IDENTITY( ), see BOL.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply