How to use stored procedure with Acess ???

[oxbow123]

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

[hellswraith]

Unless they changed access, you can't run stored proceedures.

[hellswraith]

But check out this thread:
http://www.vbforums.com/showthread.p...hreadid=245920