odbc connection via access

Has anyone ever experienced the following.  When using MS Access with
read only priv. via an ODBC connection to ASA having duplicate rows of a
table displayed?  Upon investigating it's just that, the duplicates are
only being displayed (hundreds of times) the actual db is fine.  Any
suggestions.  It's version 5.5.04.

If you have written a query with multiple tables you may have left off 
the necessary syntax to join the tables in a logical way.  If you leave 
off the join syntax you'll get a Cartesian join which joins every row 
with every other row from each table.
-- 
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm

There is only one table being accessed and no query is being run against
it, just an opening of the table.


Jim Egan wrote:

> If you have written a query with multiple tables you may have left off
> the necessary syntax to join the tables in a logical way.  If you leave
> off the join syntax you'll get a Cartesian join which joins every row
> with every other row from each table.
> --
> Jim Egan [TeamSybase]
> Houston, TX
> http://www.eganomics.com
>
> Sybase Developers Network
> http://sdn.sybase.com/sdn/mec/mec_home.stm

jtd wrote:
> 
> Has anyone ever experienced the following.  When using MS Access with
> read only priv. via an ODBC connection to ASA having duplicate rows of a
> table displayed?  Upon investigating it's just that, the duplicates are
> only being displayed (hundreds of times) the actual db is fine.  Any
> suggestions.  It's version 5.5.04.

I'm scraping the bottom of my brain cells here, but you might want to
look into how Access deals with case-insensitive searches. As you know,
SQLA defaults to case-insensitive searches unless you change the
database option to do otherwise. We had this problem with the Borland
Database Engine; my partner modified the default SQLA (Dic850)
dictionary and we specified it in the BDE LANGDRIVER option. And no, I
don't know what modification he made. If somebody could refresh my
memory about how to extract the dictionary to an ascii file, I could
probably run a delta between what we're using and sademo.db.

HTH,
Kathleen

I don't know what else the problem could be.  I don't use access.
-- 
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm

Hello

I also had the same problem with ASA 6.0.3
But in my case only some recods where dublicated.
How I remember it was related with field, and with his index.

Linas Kavolius



"jtd"  wrote in message
news:[email protected]...
> Has anyone ever experienced the following.  When using MS Access with
> read only priv. via an ODBC connection to ASA having duplicate rows of a
> table displayed?  Upon investigating it's just that, the duplicates are
> only being displayed (hundreds of times) the actual db is fine.  Any
> suggestions.  It's version 5.5.04.
>
>
>