Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.basic.visual.misc > #1374

Re: VBA code to dynamically create an SQL query for Access db

From "Farnsworth" <nospam@nospam.com>
Newsgroups comp.lang.basic.visual.misc
Subject Re: VBA code to dynamically create an SQL query for Access db
Date 2012-07-18 15:03 -0400
Organization Aioe.org NNTP Server
Message-ID <ju71a2$g2e$1@speranza.aioe.org> (permalink)
References <1e0600a4-e7ef-4eff-9001-45c41482ec1b@googlegroups.com> <ju6hrm$7pt$2@speranza.aioe.org> <141ae15f-9c79-44e1-bfef-d894b1f96715@googlegroups.com> <d2rd08p72cqps5ilngj46j74n91jltgktr@4ax.com>

Show all headers | View raw

"ralph" <nt_consulting64@yahoo.com> wrote in message 
news:d2rd08p72cqps5ilngj46j74n91jltgktr@4ax.com...
> One of the first rules of database design is to keep Data separate
> from Presentation. (Actually there are so many "first rules" in
> design, not sure if this is THE first rule or not, but certainly
> deserves honorable mention. <g>)
>
> The second you decided to design a table to be a 'view', you were in
> trouble. Logically store and normalize your data - then write Views as
> needed.
>
> -ralph

I agree with Ralph. Here is a link to show what database normalization means 
in case you weren't familiar with it:

http://en.wikipedia.org/wiki/Database_normalization

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-18 04:54 -0700
  Re: VBA code to dynamically create an SQL query for Access db Deanna Earley <dee.earley@icode.co.uk> - 2012-07-18 15:39 +0100
    Re: VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-18 08:10 -0700
      Re: VBA code to dynamically create an SQL query for Access db Deanna Earley <dee.earley@icode.co.uk> - 2012-07-18 17:54 +0100
      Re: VBA code to dynamically create an SQL query for Access db ralph <nt_consulting64@yahoo.com> - 2012-07-18 12:24 -0500
        Re: VBA code to dynamically create an SQL query for Access db "Farnsworth" <nospam@nospam.com> - 2012-07-18 15:03 -0400
        Re: VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-19 01:24 -0700
          Re: VBA code to dynamically create an SQL query for Access db ralph <nt_consulting64@yahoo.com> - 2012-07-19 11:00 -0500

csiph-web