Sorry for the late reply. We are moving to our brand new building today, or rather packing up as the movers are doig the actualy moving for us, so there has been no internet access etc. at work since we have to move 20 odd servers !! PLUS....since we use I think its Walker Wireless or who ever they are called now, and even tho the new building is right behind our current one, they cant get a signal..DOH !! Hehehe gotta laugh...so we got off early :-)
ANYWAY....in defense of your comment Neven that Access is a dog, which I still don’t really agree with, a badly designed database is even worse. It’s a dog with three legs. So if you design a good Access DB, then atleast,if you continue to thingk of Access as a dog...which I don’t.. it’s a grey-hound :-) Don’t get me wrong, Access is a total pain in the arse for me at times. Esp. when I come home from work after writing Stored Procs in MSSQL and think..."MAN if only I could use Stored Procs !!" But like I say, it really doesn’t peform very badly for our situation/s and customers have never complained about speed. Its all in the design and what you place you keys on. The other reason we still use access is because of the time to swap over to MSDE, which is pretty much where we will go. I have however made the transition hopfully a bit smoother by not binding controls etc. and using standard SQL etc. BUT in a final comment....anyone used DBISAM over a network connection?? Now that IS A DOG !! In fact, it’s a dog with only 2 legs !! Jeremy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: 10 March 2006 10:37 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] List working? Jeremy Yes everybody has a story where #THEY# got a dog to do tricks, It still doesn't alter the fact that its a dog > BUT in saying that And your point is? Neven Jeremy Coulter wrote: > 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 > > -- Neven MacEwan (B.E. E&E) Ph. 09 620 1356 Mob. 027 4749 062 New Address Details =================== MWK Computer Systems 1 Taumata Rd Sandringham Auckland Ph 620 1356 Fx 620 1336 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 09/03/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 09/03/2006 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
