By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,705 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,705 IT Pros & Developers. It's quick & easy.

Could we write stored procedures in MS Access

P: 46
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
Jun 6 '07 #1
Share this Question
Share on Google+
3 Replies

FishVal
Expert 2.5K+
P: 2,653
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.
Jun 7 '07 #2

P: 46
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
Jun 11 '07 #3

FishVal
Expert 2.5K+
P: 2,653
===============

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
Jun 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.