At 09:54 AM 1/8/2008, Edwin Marzan wrote: >Perhaps MS Access is not the best product for this application but >believe me, it is an extremely powerful database application >especially in my work environment where I specialize in complex >report writing. If you're going to import ten million rows of data >daily, you'll need SQL Server or somesuch. If you're working with 4 >thousand rows of new data per month then Access is the way to go. >It's all about using the right tool for the right job.
No question there.. My wife does lots of analysis downloading batches of data (of that general size) out of corporate SQL databases into Access, and then doing the manipulation. I think of it as Matlab for databases.. it's interactive, reasonably fast, and sophisticated enough to get real work done. I think most of the MSAccess issues crop up over long term usage (as DLLs get updated underneath, or in a development environment). Certainly, in my own limited use, it's always been when trying to work with mdbs that are a year or more old, not with day to day stuff. But then, that's just the situation we have with PowerSDR.. you have a database that you built with a released version of PowerSDR, and now, you're loading into the latest SVN a year later, and who knows whether the manifestation of the db engine in your current build matches that of the older one. I also have a philosophical problem with binding the user interface directly to the database. Seems too much of the old "build your database from the description of the screen form" style of database popular in the 80s. That works fine when building a db consisting of a couple flat files that fit on a 360k floppy, but starts to get ungainly as the size or complexity of the database grows. It makes it real hard to tell if a change in the database schema will break your UI. But that's just me. Jim _______________________________________________ FlexRadio Systems Mailing List [email protected] http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
