View Single Post
  #63  
Old September 5th, 2008, 07:53 AM posted to microsoft.public.access
Please Learn to Read[_2_]
external usenet poster
 
Posts: 13
Default SQL code works in Access SQL window but not in VBA SQL code

Please, sir, seek a basic "Learn To Read" course at a local welfare or
educational organization. The word "tier" nor "tiers" has been mentioned in
this message thread, except in your posts. But, perhaps it is not a matter
of just not knowing how to read. There are also public free clinics for the
unemployed and poor, as you surely must be, to determine if you need
corrective lenses. If you get some vision correction, maybe you will be able
to get the words right.

2008 Learn To Read Campaign


"a a r o n . k e m p f @ g m a i l . c o" wrote:

YOU MVP DORKS are defending 3 tiers-- if not FOUR tiers of Jet
databases.

a) one for lookup tables
b) one for big tables
c) one for temporary tables
d) one for front end.

Personally-- I think that having FOUR MDB files-- or ONE ADP? I choose
ONE ADP any day of the week.

-Aaron





On Aug 11, 11:43 am, posted_by_anonymous
wrote:
"a a r o n . k e m p f @ g m a i l . c o" wrote:

you don't need 3 tiers of tables.


keep data where it belongs- on a db server


Yep, as dcap says, "Aaron is an idiot, a liar, and a convicted criminal."

Nobody's suggested "3 tiers of tables." Nothing in this thread, except
aaron's rants, raves, and babbling had anything to do with "tiers of tables".
But using both local and remote (including server) tables can improve
performance.

Oh, and sorry, spoke too soon about eliminating this thread... guess it was
just the "online interface screwing up", not "the wimps protecting aaron from
his own blunders".

Anony Mous