> -----Original Message----- > From: Craig Thomas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 5:25 PM > To: CF-Talk > Subject: RE: mySQL vs. Access or MSDE > > > >>> Anyone have a feeling about the Microsoft Data Engine, which > > is supposed to be a limited connection version of SQL that > > can upscale to SQL very easily rather than Access? > > It is SQL Server, essentially, with some minor limitations. I've > worked with > it quite a bit, and like it for use instead of Access.<< > > I (mistakenly?) understood it only worked in a 'desktop' environment, > running in the background of, say a VB app. Is that wrong?
It runs on Windows 2000 Server as well, and handles concurrency a lot better than Access. I work and have worked with it on past projects and it's so nice to be able to develop on my full-blown development server with SQL Server 2000 and port it over to MSDE. Sure, that might be backwards somewhat, but cost-wise clients like it much better when they have low-hit sites, since it's a true database server. You just have to make sure they understand that it won't handle high load like the full application. Porting your database(s) to and from MSDE is quite painless, in my experience. --Andy ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
