I was wondering if there is any way i am able to use stored procedures and triggers in access.
No Triggers i think maybe not SP is a no (from my knowledge) Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jamie Lawrence Jenner Sent: Tuesday, April 20, 2004 12:29 AM To: CFAussie Mailing List Subject: [cfaussie] stored procs and triggers in access Hi, I was wondering if there is any way i am able to use stored procedures and triggers in access. I know that i am able to access queries within the database using ADO but i am not able to carry out select queries, only delete, update and append. The database will be upgraded to SQL eventually but it has to remain in access at the moment. I have a particularly large amount (over 30) queries which run when a user su bmits a customers order. there are numerous insert deletes, selects and updates and at the moment each query is run seperatly withints own cfquery tag. this is causing a massive bottleneck as it is also a transaction and it would be more efficient to run within the database. how do i carry out stored procs and triggers in access and how do i access them? thanks in advance Jamie --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
