I add a record into a db and then retrieve the RecordID right below it like this:<BR>Dim rsIdentity<BR>set rsIdentity = Conn.Execute("SELECT @@IDENTITY FROM DOCUMENTS")<BR>Response.Write "ID:" & rsIdentity.fields(0)<BR>The response.write is holding no value. I checked the db, the record inserted fine. I copied the code to get the identity from another one of my websites where it works fine. The table name is correct. Any ideas? I'm not getting any errors and I don't have on error resume next anywhere on the page.....<BR>K.