> Ah, the luxury of having a real RDBMS to play with! > > I agree, doing some/lots of the processing (with optional input parameters) within the > database is ideal but I'm having to resort to multiple SP's with <CFIF> when dealing with > JET/MSAccess.
For those of you who havent heard, Microsoft have a product called MSDE ( Microsoft Database Engine ). It is the core engine from SQL Server 2000, and is included with many microsoft products. The licensing isnt onerous ( if you bought something that has it, then you have a distribution license ). It includes Enterprise Manager, and as far as you need to be concerned, it operates just like SQL Server 2000. It has a few limitations, 2gb max DB size, only 16 instances per server, only 5 concurrent connections ( others are queued ). Basically, if you are using Access for your site back end, then you should look at MSDE. It is really good. The only issue you might have is using it in a shared hosted environment, but the host should offer SQL Server DB's anyway. If you don't have any MS software with it already, search on google for 'web matrix', which is MS's free .Net IDE, and it also has a download for MSDE, also free. The license in that case only allows deployment with Web Matrix apps. But you can use it locally for whatever you want. Its 70mb for MSDE. Jon Hart. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
