A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SQL code works in Access SQL window but not in VBA SQL code



 
 
Thread Tools Display Modes
  #61  
Old August 12th, 2008, 02:57 PM posted to microsoft.public.access
bcap[_2_]
external usenet poster
 
Posts: 260
Default SQL code works in Access SQL window but not in VBA SQL code

Ignore Kempf, he is an idiot, a liar, and a convicted criminal.


  #62  
Old August 12th, 2008, 03:00 PM posted to microsoft.public.access
a a r o n . k e m p f @ g m a i l . c o m
external usenet poster
 
Posts: 1,108
Default SQL code works in Access SQL window but not in VBA SQL code

the kid says he has db corruption.
you don't believe him?

you're such a loser.

if your database corrupts-- move to a real database.

PERIOD.


On Aug 12, 6:57*am, "bcap" wrote:
Ignore Kempf, he is an idiot, a liar, and a convicted criminal.


  #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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.