Could we write stored procedures in MS Access

[chaitanya02]

Hi All,

Please let me know, if we could write Stored Procedures in MS Access.
I have a 4 tables like this:

sql1-account id, name
sql2-account id,email id
sql3-account id, cstart date, cend date,downloadurl,contact,status
sql4-name, userid, pwd


i want to see if cstart date=system data, then run a stored procedure, when ever this condition is fulfilled- and generate a userid and the pwd mapping the account id in sql3 to name in sql1. And this to account id in sql2..and tka ethe email id in sql2 corresponding to that account id- and send the download url in sql3 corresponding to the one in sql3....

This might sound complicated- but the way they are realted is simple..account id is pri key...So, all I need is a stored procedure that could be run on the Access db, to generate a 'download url' that corresponds to the cstartdate....

-thanks,
tanya