GETTING @@IDNETITY FROM SQL THRU ACCESS

[LonnieJohnson]

HOW DO I RETRIEVE THIS VALUE BACK FROM SQL SERVER INTO AN ACCESS VARIABLE? I AM INSERTING NEW RECORDS INTO SQL FROM ACCESS AND I WOULD LIKE TO USE THE RECORDID (@@IDENTITY) FROM SQL.


prodevmg@yahoo.com
ProDev, MS Access Applications B-)

May God bless you in the year 2002.

 

[AnnYH]

I guess your table have PK it is autonumber.
And you used Dao to insert new record, SQL server not like Access, you must change to ADO.
It¡¯ll work fine.
This one happened to me. If my table has a autonumber, the vb code must be changed from Dao to ADO.

I hope it can help you. Good luck!

AnnYH

 

[LonnieJohnson]

Thanks. I found that out this morning. You are exactly correct. You must run your SQL INSERT query thru ADO on the SQL platform, then send a SELECT for the IDENTITY. A97 cannot do this via DAO, only ADO.

Thanks for the confirmation. prodevmg@yahoo.com
ProDev, MS Access Applications B-)

May God bless you in the year 2002.