Help, pls...
i have a program that uses mssql for its database.In my program, i use a stored procedure to insert a datarow in the database wherein the stored procedure also returns the Last Identity number of the row being inserted.
Now, I am converting the database to Access however, there are no stored procedure in Access, so I have to do some programming in my program so that it would still be flexible. My problem now is, How can i get the last identity number (the autonumber field) being assigned to the datarow being inserted?
please help..
i have a program that uses mssql for its database.In my program, i use a stored procedure to insert a datarow in the database wherein the stored procedure also returns the Last Identity number of the row being inserted.
Now, I am converting the database to Access however, there are no stored procedure in Access, so I have to do some programming in my program so that it would still be flexible. My problem now is, How can i get the last identity number (the autonumber field) being assigned to the datarow being inserted?
please help..