I am using vb6 with ado

I was used to use addnew with a recordset

but so I will use somthing like

"insert into dbo_invoice (invoice_id, invoice_date) select max(invoice_id)+1 as new_id, getdate() from dbo_invoice"

what will gurantee that using

rs.open "SELECT @@IDENTITY AS 'Identity'"

will return the Id created by the application current user and not by the some other user??

Offcourse I need for the application to know which one it created in order to open the form with the new id just created!