Tillbaka till svenska Fidonet
English   Information   Debug  
OS2BBS   0/787
OS2DOSBBS   0/580
OS2HW   0/42
OS2INET   0/37
OS2LAN   0/134
OS2PROG   0/36
OS2REXX   0/113
OS2USER-L   207
OS2   0/4779
OSDEBATE   0/18996
PASCAL   0/490
PERL   0/457
PHP   0/45
POINTS   0/405
POLITICS   0/29554
POL_INC   0/14731
PSION   103
R20_ADMIN   1117
R20_AMATORRADIO   0/2
R20_BEST_OF_FIDONET   13
R20_CHAT   0/893
R20_DEPP   0/3
R20_DEV   399
R20_ECHO2   1379
R20_ECHOPRES   0/35
R20_ESTAT   0/719
R20_FIDONETPROG...
...RAM.MYPOINT
  0/2
R20_FIDONETPROGRAM   0/22
R20_FIDONET   0/248
R20_FILEFIND   0/24
R20_FILEFOUND   0/22
R20_HIFI   0/3
R20_INFO2   2632
R20_INTERNET   0/12940
R20_INTRESSE   0/60
R20_INTR_KOM   0/99
R20_KANDIDAT.CHAT   42
R20_KANDIDAT   28
R20_KOM_DEV   112
R20_KONTROLL   0/13030
R20_KORSET   0/18
R20_LOKALTRAFIK   0/24
R20_MODERATOR   0/1852
R20_NC   76
R20_NET200   245
R20_NETWORK.OTH...
...ERNETS
  0/13
R20_OPERATIVSYS...
...TEM.LINUX
  0/44
R20_PROGRAMVAROR   0/1
R20_REC2NEC   534
R20_SFOSM   0/340
R20_SF   0/108
R20_SPRAK.ENGLISH   0/1
R20_SQUISH   107
R20_TEST   2
R20_WORST_OF_FIDONET   12
RAR   0/9
RA_MULTI   106
RA_UTIL   0/162
REGCON.EUR   0/2055
REGCON   0/13
SCIENCE   0/1206
SF   0/239
SHAREWARE_SUPPORT   0/5146
SHAREWRE   0/14
SIMPSONS   0/169
STATS_OLD1   0/2539.065
STATS_OLD2   0/2530
STATS_OLD3   0/2395.095
STATS_OLD4   0/1692.25
SURVIVOR   0/495
SYSOPS_CORNER   0/3
SYSOP   0/84
TAGLINES   0/112
TEAMOS2   0/4530
TECH   0/2617
TEST.444   0/105
TRAPDOOR   0/19
TREK   0/755
TUB   0/290
UFO   0/40
UNIX   0/1316
USA_EURLINK   0/102
USR_MODEMS   0/1
VATICAN   0/2740
VIETNAM_VETS   0/14
VIRUS   0/378
VIRUS_INFO   0/201
VISUAL_BASIC   0/473
WHITEHOUSE   0/5187
WIN2000   0/101
WIN32   0/30
WIN95   0/4275
WIN95_OLD1   0/70272
WINDOWS   0/1517
WWB_SYSOP   0/419
WWB_TECH   0/810
ZCC-PUBLIC   0/1
ZEC   4

 
4DOS   0/134
ABORTION   0/7
ALASKA_CHAT   0/506
ALLFIX_FILE   0/1313
ALLFIX_FILE_OLD1   0/7997
ALT_DOS   0/152
AMATEUR_RADIO   0/1039
AMIGASALE   0/14
AMIGA   0/331
AMIGA_INT   0/1
AMIGA_PROG   0/20
AMIGA_SYSOP   0/26
ANIME   0/15
ARGUS   0/924
ASCII_ART   0/340
ASIAN_LINK   0/651
ASTRONOMY   0/417
AUDIO   0/92
AUTOMOBILE_RACING   0/105
BABYLON5   0/17862
BAG   135
BATPOWER   0/361
BBBS.ENGLISH   0/382
BBSLAW   0/109
BBS_ADS   0/5290
BBS_INTERNET   0/507
BIBLE   0/3563
BINKD   0/1119
BINKLEY   0/215
BLUEWAVE   0/2173
CABLE_MODEMS   0/25
CBM   0/46
CDRECORD   0/66
CDROM   0/20
CLASSIC_COMPUTER   0/378
COMICS   0/15
CONSPRCY   0/899
COOKING   27601
COOKING_OLD1   0/24719
COOKING_OLD2   0/40862
COOKING_OLD3   0/37489
COOKING_OLD4   0/35496
COOKING_OLD5   9370
C_ECHO   0/189
C_PLUSPLUS   0/31
DIRTY_DOZEN   0/201
DOORGAMES   0/1974
DOS_INTERNET   0/196
duplikat   5999
ECHOLIST   0/18295
EC_SUPPORT   0/318
ELECTRONICS   0/359
ELEKTRONIK.GER   1534
ENET.LINGUISTIC   0/13
ENET.POLITICS   0/4
ENET.SOFT   0/11701
ENET.SYSOP   33774
ENET.TALKS   0/32
ENGLISH_TUTOR   0/2000
EVOLUTION   0/1335
FDECHO   0/217
FDN_ANNOUNCE   0/7068
FIDONEWS   23439
FIDONEWS_OLD1   0/49742
FIDONEWS_OLD2   0/35949
FIDONEWS_OLD3   0/30874
FIDONEWS_OLD4   0/37224
FIDO_SYSOP   12841
FIDO_UTIL   0/180
FILEFIND   0/209
FILEGATE   0/212
FILM   0/18
FNEWS_PUBLISH   4155
FN_SYSOP   41520
FN_SYSOP_OLD1   71952
FTP_FIDO   0/2
FTSC_PUBLIC   0/13559
FUNNY   0/4886
GENEALOGY.EUR   0/71
GET_INFO   105
GOLDED   0/408
HAM   0/16041
HOLYSMOKE   0/6791
HOT_SITES   0/1
HTMLEDIT   0/71
HUB203   466
HUB_100   264
HUB_400   39
HUMOR   0/29
IC   0/2851
INTERNET   0/424
INTERUSER   0/3
IP_CONNECT   719
JAMNNTPD   0/233
JAMTLAND   0/47
KATTY_KORNER   0/41
LAN   0/16
LINUX-USER   0/19
LINUXHELP   0/1155
LINUX   0/22002
LINUX_BBS   0/957
mail   18.68
mail_fore_ok   249
MENSA   0/341
MODERATOR   0/102
MONTE   0/992
MOSCOW_OKLAHOMA   0/1245
MUFFIN   0/783
MUSIC   0/321
N203_STAT   894
N203_SYSCHAT   313
NET203   321
NET204   69
NET_DEV   0/10
NORD.ADMIN   0/101
NORD.CHAT   0/2572
NORD.FIDONET   189
NORD.HARDWARE   0/28
NORD.KULTUR   0/114
NORD.PROG   0/32
NORD.SOFTWARE   0/88
NORD.TEKNIK   0/58
NORD   0/453
OCCULT_CHAT   0/93
Möte OSDEBATE, 18996 texter
 lista första sista föregående nästa
Text 3560, 545 rader
Skriven 2005-04-10 18:39:38 av Rich (1:379/45)
   Kommentar till text 3559 av Mike '/m' (1:379/45)
Ärende: Re: wrong data from oracle
==================================
From: "Rich" <@>

This is a multi-part message in MIME format.

------=_NextPart_000_07D5_01C53DFC.A6FA94A0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

   Here you go spinning again.  Your complaint below is that the oracle =
ODBC driver doesn't identify the primary index so Access (actually JET) = has
to guess based on what oracle does return.  Again, had you actually = read the
KB article without prejudice before you try tossing blame = around you would
have seen that Access (JET) is doing nothing wrong.  It = uses the only
information it has.

   Yes, it does say that it may select the wrong one because that is =
true if you are trying to infer the primary index from information that = does
not identify the primary index.  It does not claim this is an = Access problem.
 You even pointed out that this is clearly identified as = by design.

   I see you intentionally fail to point out the statement "NOTE: When =
using SQL Server version 6.x, this behavior only occurs if you are using =
non-clustered unique indexes."  Maybe you should switch from oracle to a =
better database server like Microsoft SQL Server.

   You also fail to point out that this only occurs when linking to an =
ODBC data source and not when accessing ODBC in general.

   Finally, you fail to identify why the primary attribute on a linked =
table results in you getting a wrong result.  Do you even have a =
justification to blame this behavior or is this typical Mike Miller = behavior
to blame Microsoft or someone else for your own failures?

Rich

  "Mike '/m'" <mike@barkto.com> wrote in message =
news:h4hj51pstulobak108hiv6ot7bktf2o3bo@4ax.com...
  >If you have complaints about drivers for oracle maybe you should ask =
oracle to provide you with ODBC or OLEDB drivers that you can use with = their
server.


  I have no complaints about the ODBC drivers for Oracle.  Except for =
the
  times we use them with MS Access, the Oracle ODBC drivers have worked
  very well.  A typical, though failed, attempt on your part to divert =
the
  discussion.

  The KB articles mention that the problem exists with MS SQL Server =
also.
  "When you link a table from an ODBC data source, such as Microsoft SQL
  Server or ORACLE, and that table contains more than one unique index,
  Microsoft Access may select the wrong index as the primary key."

  Note that the KB article says that "Microsoft Access may select the
  wrong index..."  As much as you would like it to be the case, the
  problem has nothing to do with Oracle.

  The KB article says it is a MS Access problem.

  Nice try, though.

   /m



  On Sun, 10 Apr 2005 17:14:50 -0700, "Rich" <@> wrote:

  >   Again you see what you want to see and throw blame where you have =
prejudged.  If you have complaints about drivers for oracle maybe you = should
ask oracle to provide you with ODBC or OLEDB drivers that you can = use with
their server.
  >
  >Rich
  >
  >  "Mike '/m'" <mike@barkto.com> wrote in message =
news:15fj519svfug1ued6e3cbnm6g23jgkd41p@4ax.com...
  >
  >  What I wanted to see was the correct data.  What I did not see was =
the
  >  correct data.=20
  >
  >  Ten years and this bug has not been fixed.
  >
  >   /m
  >
  >
  >
  >  On Sun, 10 Apr 2005 16:49:14 -0700, "Rich" <@> wrote:
  >
  >  >   It just goes to show that you see what you want to see.  Had =
you actually read the KB articles someone not prejudiced would see that = that
the reason an unintended index may be selected is that ODBC does = not return
the primary index and that the index must be guessed.  = Nowhere does it claim
that wrong data is returned.
  >  >
  >  >Rich
  >  >
  >  >  "Mike '/m'" <mike@barkto.com> wrote in message =
news:6e8j51t7a8r68aktqpe4q5aqhp7h6curd7@4ax.com...
  >  >
  >  >  btw, for more info:
  >  >
  >  >  SYMPTOMS
  >  >  When you link (attach) a table from an ODBC data source, such as
  >  >  Microsoft SQL Server or ORACLE, and that table contains more =
than one
  >  >  unique index, Microsoft Access may select the wrong index as the =
primary
  >  >  key.
  >  >
  >  >  http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;292047
  >  >
  >  >  http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;169777
  >  >
  >  >  Notice the "This behavior is by design." under the Status =
category of
  >  >  the second link.
  >  >
  >  >  The existence of this problem, and Microsoft's lack of interest =
in
  >  >  resolving it, was noticed at the CEO and CFO level in my =
company.  I
  >  >  suspect that such a cavalier attitude by Microsoft towards the =
validity
  >  >  of the results that MS Access provides will not be A [long-term] =
Good
  >  >  Thing for Microsoft at my company.
  >  >
  >  >  The question I cannot understand is how can Microsft leave such =
a known
  >  >  and critical bug unfixed for over ten years?
  >  >
  >  >   /m
  >  >
  >  >  On Sun, 10 Apr 2005 14:42:55 -0700, Ellen K.
  >  >  <72322.enno.esspeayem.1016@compuserve.com> wrote:
  >  >
  >  >  >That's pretty gross all right.
  >  >  >
  >  >  >What versions of Access and Oracle?
  >  >  >
  >  >  >I used Access 97 against Oracle 8i at Kaiser without this =
problem, and
  >  >  >know I didn't have it because I would periodically check the =
Oracle data
  >  >  >(retrieved using Access) against the DB2 data on the mainframe
  >  >  >(retrieved interactively) of which it was a clone.
  >  >  >
  >  >  >On Sun, 10 Apr 2005 12:10:42 -0400, Mike '/m' <mike@barkto.com> =
wrote in
  >  >  >message <d5ji511u416i5k7mrgpcdrrk8h8b8ljbtb@4ax.com>:
  >  >  >
  >  >  >>On Sun, 10 Apr 2005 09:51:59 -0400, "Geo" <georger@nls.net> =
wrote:
  >  >  >>
  >  >  >>>"Adam Flinton" <adam@NOSPAM_softfab.com> wrote in message
  >  >  >>>news:4258f782$1@w3.nls.net...
  >  >  >>>
  >  >  >>>> Anyway....the point that was made then was along the lines =
of that's it
  >  >  >>>> for upgrades of office coz quite frankly the users have =
everything they
  >  >  >>>> need now
  >  >  >>>
  >  >  >>>I don't think MS realizes yet what it was that powered that =
growth surge
  >  >  >>>they had in the 90's.
  >  >  >>>
  >  >  >>>[snip]
  >  >  >>>
  >  >  >>>As for Office, we never used it. We went with Works because =
our users simply
  >  >  >>>don't have the skills to require more than that. We've got =
maybe 4 copies of
  >  >  >>>Office  but only so we can convert files we get from =
customers, and we
  >  >  >>>convert those to paper <g>.
  >  >  >>>
  >  >  >>>When I order new computers, I order them without hard drives =
as a way to
  >  >  >>>insure that I'm not going to pay for any new copies of an OS =
I'm not going
  >  >  >>>to be using. (well except for laptops)
  >  >  >>
  >  >  >>We use MS Office across the board where I work.  =
Unfortunately, MS
  >  >  >>Access is becoming entrenched as well.  That is frightening =
because of
  >  >  >>all the problems it has, especially the one we found last =
week.  MS
  >  >  >>Access seems to return "unexpected results" when used with an =
ODBC
  >  >  >>connection in some instances.  We had production and =
accounting people
  >  >  >>making customer-affecting decisions based upon the bad data =
that MS
  >  >  >>Access was returning.  The Software Engineer (one of the most =
senior on
  >  >  >>the team) wrote this in his status report:
  >  >  >>
  >  >  >>=3D=3D=3D
  >  >  >>Worked with [names of users and other Software Engineers =
deleted to
  >  >  >>protect the innocent] to design and implement a work-around =
for a
  >  >  >>stunningly stupid bug in Microsoft Access.  When Access is =
used to
  >  >  >>view/update an Oracle table, it sometimes fetches the wrong =
rows.  There
  >  >  >>is no error or warning.  The bad data could easily be accepted =
and used
  >  >  >>in producing a sample, updating panelist accounts, or whatever =
the user
  >  >  >>is doing.... This bug has existed for over ten years, and is =
documented
  >  >  >>on Microsoft's web site.  They apparently have no interest in =
fixing
  >  >  >>it....
  >  >  >>=3D=3D=3D
  >  >  >>
  >  >  >>For that particular Software Engineer to use the phrase =
"stunningly
  >  >  >>stupid bug" (he bolded and italicized it) in his status report =
is
  >  >  >>amazing.  He is usually (nearly always) very low-key.  *Very* =
low key. =20
  >  >  >>
  >  >  >>
  >  >  >> /m
  >  >  >>
  >  >  >>
  >  >  >>
  >  >  >>

------=_NextPart_000_07D5_01C53DFC.A6FA94A0
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; Here you go spinning =
again.&nbsp; Your=20
complaint below is that the oracle ODBC driver doesn't identify the =
primary=20
index so Access (actually JET) has to guess based on what oracle does=20
return.&nbsp; Again, had you actually read the KB article without =
prejudice=20
before you try tossing blame around you would have seen that Access=20
(JET)&nbsp;is doing nothing wrong.&nbsp; It uses the only information it =

has.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; Yes, it does say that it =
may select=20
the wrong one because that is true if you are trying to infer the = primary
index=20
from information that does not identify the primary index.&nbsp; It does =
not=20
claim this is an Access&nbsp;problem.&nbsp; You even pointed out that = this
is=20
clearly identified as by design.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; I see you intentionally =
fail to point=20
out the statement "NOTE: When using SQL Server version 6.x, this = behavior
only=20
occurs if you are using non-clustered unique indexes."&nbsp; Maybe you =
should=20
switch from oracle to a better database server like Microsoft SQL=20
Server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; You also fail to point out =
that this=20
only occurs when linking to an ODBC data source and not when accessing = ODBC
in=20
general.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; Finally, you fail to =
identify why the=20
primary attribute on a linked table results in you getting a wrong =
result.&nbsp;=20
Do you even have a justification to blame this behavior or is this = typical
Mike=20
Miller behavior to blame Microsoft or someone else for your own=20
failures?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Rich</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Mike '/m'" &lt;<A =
href=3D"mailto:mike@barkto.com">mike@barkto.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:h4hj51pstulobak108hiv6ot7bktf2o3bo@4ax.com">news:h4hj51pstul=
obak108hiv6ot7bktf2o3bo@4ax.com</A>...</DIV>&gt;If=20
  you have complaints about drivers for oracle maybe you should ask =
oracle to=20
  provide you with ODBC or OLEDB drivers that you can use with their=20
  server.<BR><BR><BR>I have no complaints about the ODBC drivers for=20
  Oracle.&nbsp; Except for the<BR>times we use them with MS Access, the =
Oracle=20
  ODBC drivers have worked<BR>very well.&nbsp; A typical, though failed, =
attempt=20
  on your part to divert the<BR>discussion.<BR><BR>The KB articles =
mention that=20
  the problem exists with MS SQL Server also.<BR>"When you link a table =
from an=20
  ODBC data source, such as Microsoft SQL<BR>Server or ORACLE, and that =
table=20
  contains more than one unique index,<BR>Microsoft Access may select =
the wrong=20
  index as the primary key."<BR><BR>Note that the KB article says that=20
  "Microsoft Access may select the<BR>wrong index..."&nbsp; As much as =
you would=20
  like it to be the case, the<BR>problem has nothing to do with=20
  Oracle.<BR><BR>The KB article says it is a MS Access =
problem.<BR><BR>Nice try,=20
  though.<BR><BR>&nbsp;/m<BR><BR><BR><BR>On Sun, 10 Apr 2005 17:14:50 =
-0700,=20
  "Rich" &lt;@&gt; wrote:<BR><BR>&gt;&nbsp;&nbsp; Again you see what you =
want to=20
  see and throw blame where you have prejudged.&nbsp; If you have =
complaints=20
  about drivers for oracle maybe you should ask oracle to provide you =
with ODBC=20
  or OLEDB drivers that you can use with their=20
  server.<BR>&gt;<BR>&gt;Rich<BR>&gt;<BR>&gt;&nbsp; "Mike '/m'" &lt;<A=20
  href=3D"mailto:mike@barkto.com">mike@barkto.com</A>&gt; wrote in =
message <A=20
  =
href=3D"news:15fj519svfug1ued6e3cbnm6g23jgkd41p@4ax.com">news:15fj519svfu=
g1ued6e3cbnm6g23jgkd41p@4ax.com</A>...<BR>&gt;<BR>&gt;&nbsp;=20
  What I wanted to see was the correct data.&nbsp; What I did not see =
was=20
  the<BR>&gt;&nbsp; correct data. <BR>&gt;<BR>&gt;&nbsp; Ten years and =
this bug=20
  has not been fixed.<BR>&gt;<BR>&gt;&nbsp;&nbsp;=20
  /m<BR>&gt;<BR>&gt;<BR>&gt;<BR>&gt;&nbsp; On Sun, 10 Apr 2005 16:49:14 =
-0700,=20
  "Rich" &lt;@&gt; wrote:<BR>&gt;<BR>&gt;&nbsp; &gt;&nbsp;&nbsp; It just =
goes to=20
  show that you see what you want to see.&nbsp; Had you actually read =
the KB=20
  articles someone not prejudiced would see that that the reason an =
unintended=20
  index may be selected is that ODBC does not return the primary index =
and that=20
  the index must be guessed.&nbsp; Nowhere does it claim that wrong data =
is=20
  returned.<BR>&gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;Rich<BR>&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; "Mike '/m'" &lt;<A=20
  href=3D"mailto:mike@barkto.com">mike@barkto.com</A>&gt; wrote in =
message <A=20
  =
href=3D"news:6e8j51t7a8r68aktqpe4q5aqhp7h6curd7@4ax.com">news:6e8j51t7a8r=
68aktqpe4q5aqhp7h6curd7@4ax.com</A>...<BR>&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; btw, for more info:<BR>&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; SYMPTOMS<BR>&gt;&nbsp; &gt;&nbsp; When =
you link=20
  (attach) a table from an ODBC data source, such as<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  Microsoft SQL Server or ORACLE, and that table contains more than=20
  one<BR>&gt;&nbsp; &gt;&nbsp; unique index, Microsoft Access may select =
the=20
  wrong index as the primary<BR>&gt;&nbsp; &gt;&nbsp; key.<BR>&gt;&nbsp; =

  &gt;<BR>&gt;&nbsp; &gt;&nbsp; <A=20
  =
href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;292047"=
>http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;292047</A><BR>=
&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; <A=20
  =
href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;169777"=
>http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;169777</A><BR>=
&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; Notice the "This behavior is by design." =
under=20
  the Status category of<BR>&gt;&nbsp; &gt;&nbsp; the second =
link.<BR>&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; The existence of this problem, and =
Microsoft's=20
  lack of interest in<BR>&gt;&nbsp; &gt;&nbsp; resolving it, was noticed =
at the=20
  CEO and CFO level in my company.&nbsp; I<BR>&gt;&nbsp; &gt;&nbsp; =
suspect that=20
  such a cavalier attitude by Microsoft towards the =
validity<BR>&gt;&nbsp;=20
  &gt;&nbsp; of the results that MS Access provides will not be A =
[long-term]=20
  Good<BR>&gt;&nbsp; &gt;&nbsp; Thing for Microsoft at my =
company.<BR>&gt;&nbsp;=20
  &gt;<BR>&gt;&nbsp; &gt;&nbsp; The question I cannot understand is how =
can=20
  Microsft leave such a known<BR>&gt;&nbsp; &gt;&nbsp; and critical bug =
unfixed=20
  for over ten years?<BR>&gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp;&nbsp;=20
  /m<BR>&gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp; On Sun, 10 Apr 2005 =
14:42:55=20
  -0700, Ellen K.<BR>&gt;&nbsp; &gt;&nbsp; &lt;<A=20
  =
href=3D"mailto:72322.enno.esspeayem.1016@compuserve.com">72322.enno.esspe=
ayem.1016@compuserve.com</A>&gt;=20
  wrote:<BR>&gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;That's pretty =
gross all=20
  right.<BR>&gt;&nbsp; &gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;What =

  versions of Access and Oracle?<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;I used Access 97 against Oracle 8i at Kaiser without =
this=20
  problem, and<BR>&gt;&nbsp; &gt;&nbsp; &gt;know I didn't have it =
because I=20
  would periodically check the Oracle data<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;(retrieved using Access) against the DB2 data on the=20
  mainframe<BR>&gt;&nbsp; &gt;&nbsp; &gt;(retrieved interactively) of =
which it=20
  was a clone.<BR>&gt;&nbsp; &gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;On=20
  Sun, 10 Apr 2005 12:10:42 -0400, Mike '/m' &lt;<A=20
  href=3D"mailto:mike@barkto.com">mike@barkto.com</A>&gt; wrote =
in<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;message &lt;<A=20
  =
href=3D"mailto:d5ji511u416i5k7mrgpcdrrk8h8b8ljbtb@4ax.com">d5ji511u416i5k=
7mrgpcdrrk8h8b8ljbtb@4ax.com</A>&gt;:<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;On Sun, 10 Apr 2005 =
09:51:59=20
  -0400, "Geo" &lt;<A =
href=3D"mailto:georger@nls.net">georger@nls.net</A>&gt;=20
  wrote:<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;&gt;"Adam Flinton" &lt;<A=20
  =
href=3D"mailto:adam@NOSPAM_softfab.com">adam@NOSPAM_softfab.com</A>&gt; = wrote
in=20
  message<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;&gt;news:4258f782$1@w3.nls.net...<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;&gt; Anyway....the =
point=20
  that was made then was along the lines of that's it<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  &gt;&gt;&gt;&gt; for upgrades of office coz quite frankly the users =
have=20
  everything they<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;&gt; need=20
  now<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;&gt;I don't think MS realizes yet what it was that powered =
that growth=20
  surge<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;they had in the =
90's.<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;&gt;[snip]<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;<BR>&gt;&nbsp; =

  &gt;&nbsp; &gt;&gt;&gt;As for Office, we never used it. We went with =
Works=20
  because our users simply<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;don't =
have the=20
  skills to require more than that. We've got maybe 4 copies =
of<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;&gt;Office&nbsp; but only so we can convert files =
we get=20
  from customers, and we<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;convert =
those to=20
  paper &lt;g&gt;.<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;&gt;When I order new computers, I order them =
without hard=20
  drives as a way to<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;&gt;insure that =
I'm not=20
  going to pay for any new copies of an OS I'm not going<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;&gt;to be using. (well except for =
laptops)<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;We use MS Office =
across=20
  the board where I work.&nbsp; Unfortunately, MS<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  &gt;&gt;Access is becoming entrenched as well.&nbsp; That is =
frightening=20
  because of<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;all the problems it has,=20
  especially the one we found last week.&nbsp; MS<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  &gt;&gt;Access seems to return "unexpected results" when used with an=20
  ODBC<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;connection in some =
instances.&nbsp; We=20
  had production and accounting people<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;&gt;making=20
  customer-affecting decisions based upon the bad data that =
MS<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;Access was returning.&nbsp; The Software Engineer =
(one of=20
  the most senior on<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;the team) wrote =
this in=20
  his status report:<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  &gt;&gt;=3D=3D=3D<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;Worked with [names =
of users and=20
  other Software Engineers deleted to<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;&gt;protect=20
  the innocent] to design and implement a work-around for =
a<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;stunningly stupid bug in Microsoft Access.&nbsp; =
When=20
  Access is used to<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;view/update an =
Oracle=20
  table, it sometimes fetches the wrong rows.&nbsp; There<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;is no error or warning.&nbsp; The bad data could =
easily be=20
  accepted and used<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;in producing a =
sample,=20
  updating panelist accounts, or whatever the user<BR>&gt;&nbsp; =
&gt;&nbsp;=20
  &gt;&gt;is doing.... This bug has existed for over ten years, and is=20
  documented<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;on Microsoft's web =
site.&nbsp;=20
  They apparently have no interest in fixing<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;it....<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;&gt;=3D=3D=3D<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;For that particular Software =

  Engineer to use the phrase "stunningly<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;&gt;stupid=20
  bug" (he bolded and italicized it) in his status report =
is<BR>&gt;&nbsp;=20
  &gt;&nbsp; &gt;&gt;amazing.&nbsp; He is usually (nearly always) very=20
  low-key.&nbsp; *Very* low key.&nbsp; <BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; =
&gt;&gt;=20
  /m<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp; &gt;&gt;<BR>&gt;&nbsp; &gt;&nbsp;=20
  &gt;&gt;<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_07D5_01C53DFC.A6FA94A0--

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)