Phantom record using .adp?

[Guest]

We use MS Dynamics (Great Plains v 8.0) accounting system on SQL Server 2003
and I 've connected an .adp project (MS Access 2003) to the underlying
tables. When I run a simple query using .adp against a single table
(GL20000), the recordset contains an extra line that appears to be a
duplicate of a valid record.

If I repeat the query using SQL Query Analyzer, I get the correct results.
This is bizarre to me and I've not seen any mention of others having similar
problems.

SQL is as follows:

SELECT dbo.GL20000.*
FROM dbo.GL20000
WHERE (JRNENTRY = 46099)

Has anyone experienced this? This is amn adp show-stopper unless it can be
resolved. Thanks in advance.

 

[aaron.kempf]

ADP is showing a duplicate record?

I totally call bullshit on that.

it's called a cartesian or something.
Are you browsing the table directly, or are you using a view / sproc?

Are you _POSITIVE_ that you can't see this record using Query
Analyzer?

BTW; there is no such thing as SQL 2003-- it's Windows 2003 that runs
SQL 2000.