From: Everett L Williams II Date: 2011-02-09T05:21:54+09:00 Subject: Re: Choosing an office suite --------------050908050802070008040205 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Mike Stephens wrote: > Everett L Williams II wrote in post #980275: > >>> You must be kidding...Access has holes in it that large trucks can be >>> >> driven through, and the "Jet" engine must have flamed out in a >> rainstrom, because performance outside of single user setups is dismal. >> It also does not have referential integrity nor secure record locking. >> >> > We're trying to help a person who doesn't really want to grapple with > all sorts of technolgies. Access is much more... accessible. > > I think there's a bit of snobbishness here. SQlite is trendy whereas > Access is a rank loser. Well Jet has sophisticated view mechanisms, > supports complex sub-queries, does transactions, referential integrity, > security, replication etc etc. I've worked in some of the largest > financial companies in the World and you'd be surprised how many biga > multi-site many-user Access systems are in use everydayAnd, . > > The attraction of tools like Access (and Excel) for non-professionals is > you can experiment by seeing all the time what you are programming and > what effects it is having. > > It's not Ruby but don't dismiss this style of IT I was dismissing it because there are better, faster, simpler tools out there that are equivalent in cost and cheaper when distributed. And, referentiaql integrity is only maintained if you check all the right boxes and know about the holes that exist and correct for them. And record and page level locking is such a mess that I will never trust it, having been lied to by MS on so many occasions on the subject. They say it works, and then you find out the list of exceptions and so forth and so on, and so often, it is not in your control. The Jet engine was borrowed from Fox technology when they bought that company, and has been sadly neglected ever since. I really hate to trust MS on anything about Access. Everett L(Rett) Williams II --------------050908050802070008040205--