Can access support store procedure

[charonlee]

Hi,

I try to create procedure for access database via ASP code.
It failed,

con.Execute "CREATE PROCEDURE showName AS SELECT * FROM Names"

1.) Just wonder to know, does access allow to create store prcedure?

2.) Does it because of the ODBC can't support?

[jpjones]

Hi,
I know that stored procedures are supported only in Access 2000 and 2002, and are native to the Jet 4 Database Engine. If your version of Access is < 2000, then sadly you cannot use stored procedures.

I have yet to experiement with stored procedures in Access, and so am unable to comment on why it is not working for you.

However, if you suspect that it is not working because of ODBC, why not drag your Access database into the Access program and try creating a stored procedure in Visual Basic there? (VB because stored procedures have no GUI) If it works, you know its' ASP/ODBC which is letting you down.

HTH,
JP

Perhaps this is best moved over to the "Microsoft Related - .NET and ASP" forum?

[charonlee]

I don't have VB..so sad..