Why not use MSDE - the "free" sql server edition (if you have Visual studio, Office developer etc). It is identical to full version minus some extra stuff like dts replication, text search.
Elliot "Jamie Lawrence Jenner" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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
