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