Could we write stored procedures in MS Access

[chaitanya02]

Hi All,

Could we write a stored Procedure in asp connected to an Access db.
I have four table sin Ms Access
sql1-account id, account name
sql2-account id, email id
sql3- account id, contract number, cstart date, cend date, downloadurl, econtact, mstatus
sql4-account name, userid, pwd

I want this condition to be satisfied:

if cstart date= cend date, and email id=econtact and maintenance contract is yes- then:
retrive user id, pwd and download url from all these tables taking the account if as primary key to match 4 tables...

Anyone familiar with this, please help me in gettnig the value with a stored procedure...

Thanks,
Tanya

[FishVal]

Hi All,

Could we write a stored Procedure in asp connected to an Access db.
I have four table sin Ms Access
sql1-account id, account name
sql2-account id, email id
sql3- account id, contract number, cstart date, cend date, downloadurl, econtact, mstatus
sql4-account name, userid, pwd

I want this condition to be satisfied:

if cstart date= cend date, and email id=econtact and maintenance contract is yes- then:
retrive user id, pwd and download url from all these tables taking the account if as primary key to match 4 tables...

Anyone familiar with this, please help me in gettnig the value with a stored procedure...

Thanks,
Tanya

Hi!

Access doesn't support stored procedures as for example MSSQL does.
But Access query would be satisfying equivalent if you want to retrieve ADO.Recordset from the db.

[chaitanya02]

Hi!

Access doesn't support stored procedures as for example MSSQL does.
But Access query would be satisfying equivalent if you want to retrieve ADO.Recordset from the db.

===============

Thanks lot for the reply, could you help me with the query for the above mentioned scenario? Please...

Thanks,
Tanya

[FishVal]

===============

Thanks lot for the reply, could you help me with the query for the above mentioned scenario? Please...

Thanks,
Tanya

Will be glad to help you. Please clarify table relationships.
Particulary the following details:
1) what fields are in PK->FK relationship
2) if sql1 is in one-to-many relationship with sql4, I mean account has multiple users, it is unable to associate sql2 with sql4, because there is no direct relationship between sql4.[userid] and sql2.[email id], or maybe I'm missing the point
3) it will be perfect if you will provide mentioned tables full metadata