Re: Need help please with making this SELECT statement work!!!!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dear Mekinnik:

I second John's motion. There is a touch and feel to good database work.
Training yourself to misunderstand this "touch and feel" would be highly
counter-productive. You won't need such work-arounds if you learn to do it
right. The benefit you're getting from doing so is slight, and the
potential to have a wrong-headed approach is significant.

Tom Ellison


"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52foq19ojjkhvijqskioc0g9n0reeqflp9@xxxxxxxxxx
> On Fri, 23 Dec 2005 13:32:22 GMT, "Mekinnik via AccessMonster.com"
> <u15466@uwe> wrote:
>
>>my original design is not a relational
>>database, it is merely a flat one, however i'm still going with it just as
>>training only, my final database will be a relational one..
>
> I'd suggest that you... Stop, NOW.
>
> Training yourself on the complex getarounds needed to handle a
> non-normalized database is WASTED EFFORT.
>
> Instead, rebuild your database with normalized tables (don't worry,
> you'll be able to salvage the existing data). Learning to work within
> a properly structured environment will be MUCH MUCH more useful than
> struggling with a flawed design!
>
> John W. Vinson[MVP]


.

Relevant Pages

  • Re: Object-oriented thinking in SQL context?
    ... might be able to do by learning the syntax and semantics of SQL DDL and DML. ... MS Access integrated application building with database building, ... Desktop database work is very different from enterprise ... The terible thing about EAV is the ...
    (comp.databases.theory)
  • Re: VBSCRIPT Import CSV File Change Data Type
    ... VBScript examples, not VBA, even though the original author's name wasn't ... See http://www.QBuilt.com for all your database needs. ... >> A VB programmer or newer Access VBA programmer would have written: ... >> the database work. ...
    (microsoft.public.access.externaldata)
  • Re: Object-oriented thinking in SQL context?
    ... I contrasted the OO way of thinking with the SQL way ... MS Access integrated application building with database building, ... Desktop database work is very different from enterprise ... The terible thing about EAV is the ...
    (comp.databases.theory)
  • Re: Object-oriented thinking in SQL context?
    ... Relational databases are all ... I contrasted the OO way of thinking with the SQL way ... MS Access integrated application building with database building, ...  Desktop database work is very different from enterprise ...
    (comp.databases.theory)
  • Re: Will Jet work for this?
    ... but you can do amazing database work for single and multi-user ... LAN environments using an Access .MDB or .MDE for the front end and an ... And the back-end database is limited to 2GB total size. ...
    (comp.databases.ms-access)