How to create Stored procedure in Ms Access

[vks.gautam1]

This Stored procedure is created in sql Server. I want to create Stored procedure in Ms Access.

How to do it. Should i write stored procedure in Query in msaccess same as this. I tried but it not worked.

Create procedure[dbo].[Proc_Export]
@empid varchar(5)

as
select * from emp where empid=@empid

 

[JohnH]

DevCity.NET :: Working with MS Access Stored Procedures in VB.NET. Part 1

 

[vks.gautam1]

Thanks . Im working on it

 

[vks.gautam1]

I found two ways here for stored procedure. First directly in query & second one with the help of code. Both are working. Thanks