Hi, If you want to know how bad Mickysoft Access is ask any school that runs musac - this is a student manager program that spends more time being fixed than used. If you want sql, mdse is alright for small apps that need sql & Mickysoft compatablity.
Maurice -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Coulter Sent: Friday, 10 March 2006 10:00 a.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] List working? Actually Traci, have to disagree with you about Access. We use it with our applications that are recording live data, sometimes a record every less than a second or there abouts, and people are producing reports on the same database, and they are quite bigish in some cases too, and we dont really notice, and clients dont report any, performance issues in these situations. Ok, I have used Delphi and Access since about Delphi 2, and before that when I used to do VB stuff...VB 3... and I know a few tricks admittedly, but the one one KEY thing to do with access is make sure you do regular Compact and Repair's. We have maintenace on our apps. run every night, and it just keeps on going. BUT in saying that, I am getting concerned about the size of SOME sites, so we are looking at moving to MSDE or even Firebird, but I need to investigate the concequences of the move and how we update customers, implications of running these DB serves inline with other servers esp. SQLServer and MSDE etc. Jeremy -----Original Message----- From: "Traci Sumpter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, "'NZ Borland Developers Group - Delphi List'" <[email protected]> Cc: Date: Fri, 10 Mar 2006 08:39:38 +1300 Subject: RE: [DUG] List working? > PostgreSQL Is Really Great also!!! And Yes, Access is great for one > person > apps, Quick and Dirty solution there. However when you need to make it > multi user on network there is so much that needs to be done to keep it > reliable and still that is no guarantee either. > > "Step away from the Access" > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Grant Brown > Sent: Thursday, 9 March 2006 6:45 p.m. > To: NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] List working? > > Hi David, > > >2. Trying to move to Firebird, but after using Access for most things, > >asking myself why? > >3. Project is a simple C/S app, scaling from 1 machine to 50, possibly > >without server. > > >Having to really convince myself that Firebird is a good idea: Access > >is so much easier for a relatively small app... > > > If your going to move to c/s with 50 users then MS Access is a really > really > bad choice. > > MS Access is just a desktop DB, the performance goes through the floor > after > about 5 users logged in. > > Like you I started with MS Access but soon found out it was a big > mistake. > > Just a tip, FireBird is really good, but NexusDb is brilliant and would > be > my first choice. > > Anyway just my 2C > > Regards > Grant Brown > > > > > > > _______________________________________________ > Delphi mailing list > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi > > _______________________________________________ > Delphi mailing list > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
