I would like to create a new customer in my DB and receive back from access the primary key assigned by the DB.
In the documentation, there is a solution "stored procedure" but it work only with SQL Server.
Does someone tell me how to implement it with access
create procedure newexpediteur
@num_expediteur nchar(10)
as
insert into expediteurs (num_expediteur)
values( @num_expediteur)
return (@@key)
go
Many thanks :p
