It is possible to do "faked" stored procedures with Access.
You fake it by using a view, like so:
CREATE VIEW sp_empbydept AS
SELECT *
FROM emp
WHERE emp.dept_id = [empdeptid]
"Empdeptid" would be the parameter that you would pass into the query from
your cold fusion code.
If you run this query directly in Access, it should ask you for the
empdeptid.
Hope that gets you started.
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
