The fact that there are "freebees" out there that work better (at least for programmers) doesn't make Access seem all that good either. When Access came out I played with it. I simply could not do what I needed to do with it. Upgraded to 2.0, and found the same limitations. I have not even bothered to look at the later versions though Office 97 is loaded on my machine.
--graywolf http://graywolfphoto.com ----- Original Message ----- From: "Doug Franklin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 9:12 AM Subject: Re: Building a photo database. Any MS Access experts out there? > On Wed, 10 Sep 2003 09:15:53 +0100, Bob Walkden wrote: > > > Despite all its faults, Access is an extremely useful > > prototyping tool. > > That I'll agree with. Prototype to your heart's content. And it's OK > for small databases with low turnover in the data, if you don't mind > taking customer calls because Microsoft changed something between > Access 97 and Access 2k (or something like that). > > But I've used many different versions of the Jet engine over the years > and, based on my experience, it's nothing but trouble for (a) medium > size and up databases, (b) databases with high turnover in the records > or their contents, (c) databases with BLOBs, or (d) almost any > application that you're charging people money for. > > I've probably spent more time fixing corrupted databases or trying to > figure out incompatibilities between different versions of the Jet > engine than I have writing the code in the first place. And I'm not a > novice, either at programming or relational databases. I haven't used > the Access UI builder/environment in many moons because I can generally > get what I want faster in C/C++ than in the environment. > > Maybe I'm biased, in part, by the types of apps that I've worked on > with databases in general and Access in particular. To me, you don't > go from small to medium sized until you're talking about 100k records > or so. Large doesn't start until several million records. And SELECTs > without WHEREs are unheard of in the apps I've worked on ... the result > sets are too large. > > TTYL, DougF KG4LMZ > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/03
