Need help driving a Query in Access

[Bammy217]

Hi Folks,

I'm trying to build an intranet site for some people, and they have given me an Access DB to work from, and as I'm used to SQL I haven't a clue how to run with it, so please help me!!

Ok here's the problem I have 3 Queries in Access that if executed correctly will run on top of each other (query 1 result = query 2 input and so on...) but how do I fire the stored Query that lies within the Access Database

Thanks,
D. We never fail, we just find that the path to succes is never quite what we thought...

 

[SidianConsulting]

Queries in Access are analagous to Views in SQL Server. You'd use them just like a view:

SELECT
whatever fields you want
FROM
AccessQueryName
WHERE
whatever clause you want

Certain rules apply to queries as they do views in SQL Server, so make sure you read the docs about Queries in Access.

-Tek

 

[Bammy217]

Thanks Tek,
But I know how to write the queries (and have done succesfully) I'm just a BIG Believer in Re-Use...
So I'd rather fire the queries from within the database instead of having to place the query within cold-fusion, sortof like one uses Stored Procedures in SQL. This way I know nothing outside of the Database can be fired, and I have an easy listing of all queries used!

Thanx
D. We never fail, we just find that the path to succes is never quite what we thought...

 

[SidianConsulting]

I posted this link on another thread a ways back; it might be helpful:

http://www.sys-con.com/coldfusion/article.cfm?id=51

-Tek