Calling stored UPDATE query from Access

[JohnnyPolite]

Can someone explain to me how to call an Access update query and pass it parameters?

Thanks in advance!!! My five month old is sucking my fingers down his throat or I'd write more.

 

[Remou]

This may help.

http://www.devarticles.com/c/a/ASP/MS-Access-Tables-Views-and-Procedures/2/

 

[BigRed1212]

I'm interested in this.

Remou, I'm going to read and work through that article.

Johnny, This is what I did trying to learn about this (I posted this in another thread):

Within Access I made a query that looked like this and saved it as insert_player2

INSERT INTO registered ( fname, lname, stradd )
VALUES ([fname], [lname], [stradd]);

Obviously I think you could make an update query instead. Then my ASP form page does this after setting up the connection and getting the variable values from the requestform:

Set con = Server.CreateObject("ADODB.Connection")
con.Mode = 3
con.Open data_source
con.insert_player2 fname, lname, stradd
con.Close

HTH.

 

[Remou]

You might wish to look at this, too:

http://wiki.lessthandot.com/index.php/Access,_ADO_and_Stored_Procedures

It is a fully commented working example of using a stored query.

 

[BigRed1212]

Cool, thanks, I'll look at that too.