Sorry should have indicated only an alternative when you have control of the server environ :). It is a bit of a shame more people don't know of this option especially for intranet stuff - 2 GB limit is hardly a prob for most jobs.
"Barry Beattie" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] do shared hosting charge for this? most I know want you to use SQLServer at premium $$$ MSAccess can be transferred as easily as any file, no DTS to worry about for versioning, no roles for security (yeah also a bad point) MSAccess is an easy db solution for LITTLE sites. sometimes it's just the ticket... my 2c worth anyhoo barry.b -----Original Message----- From: Elliot Russo [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 April 2004 12:59 PM To: CFAussie Mailing List Subject: [cfaussie] Re: stored procs and triggers in access 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 --- 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
