Pass-Through Queries in MS Access

[Guest_imported]

I have several steps to this question
1. If I want to create a stored procedure on MS Access 2000
would I use the Sql Pass-Through method ....?
2. If that is the case is does this look right to anyone that has done this before
CREATE PROCEDURE test (@FName char(50), @LName char(50))
AS
DECLARE
INSERT INTO customer (Last_Name, First_Name)
VALUES (@LName, @FName)

as it stands this code does not work and I am not quite sure why .....

Please help
thanks

$help

 

[JerryDennison]

Access is not a SQL database. That is to say it is not the same as Oracle or SQL Server. Therefore, it does not use or support stored procedures. The equivalent of a stored procedure would simply be a query. But the syntax is a little different. SQL Passthrough is the ability to use Access as a front end to a SQL db whereby you can use that db's stored procedures.

 

[Guest_imported]

since I cant work with a stored procedure what would you suggest I use in this situation:
I have a COM object that is supposed to access a database(Microsoft Access)to add, update, or delete records. This COM object is receiving the information from a form on the web. Since I dont know what the values are I can only work with variables (so in this case a stored procedure is convenient)
since MS Access does not have stored procedures what would the query look like that is receiving values from another object ....? and how would I even call this query ...?
eg.
INSERT INTO table (blah, blah)
VALUES (VARIABLE, VARIABLE)

thanks
$help