Not to want to blow my trumpet too loud, but my company offers SQLServer2000 as standard with all but the most basic packages. (You can also have MySQL or Access if you want, but SQLServer2000 was what was asked about).
You can access your databases using Enterprise Manager if you want, or a web-based utility instead.
And we're running CFMX, PHP4.3.3, .asp, ASP.Net, and if you are a real thrillseeker you can even use PERL!
IF you don't see exactly what you need in the standard packages, just ask and I'm sure we can work out something to suit. I've been hosting for a few years now, and I've never before had such a flexible setup to allow me to configure sites exactly to clients' needs.
And all for a fraction of what you'd expect to pay at Web Central.Check us out at http://afpwebworks.com/index.cfm?fuseaction=DisplayDocument&DocumentID=4
Cheers
Mike Kear
AFP Webworks
Windsor, NSW, Australia.
"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
>
>
________________________________________________
Message sent using UebiMiau 2.7.2
--- 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
