Duplicate Records appear in ASP, but not in Access!!!

[tman135]

I have a very complicated Access database that has a fairly simple web interface for limited use on an intranet. The ASP page is querying a very complex access query. The access query displays the correct recordset (no duplicates), but when the recordset is then viewed via ASP, duplicate records appear.
There is no grouping in the query and the only thing I can see that might be tripping this thing up is a blank date field.

I got around the error by looking at the unique id in ASP and not writing the duplicate records out, but I'm curious if anyone has an explanation. I've only seen this with very complicated queries (10+ tables)

 

[Dynapen]

ASP shouldn't care how many tables are involved. I have run Access queries with close to 25 tables, and never had a problem with the pull by the ASP page.

Can you post some of the code you were using to pull the recordset. It would make it alot easier to help you out if I could see what was going on.

 

[Ovatvvon]

tman, I believe dynapen is right. Shouldn't matter how many tables your working with if your code is well formed.

Please provide some code for further assistence. -Ovatvvon :-Q

 

[TonyU]

Ovatvvon, why is it that every time I see you, you're licking your face.

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[RushiShroff]

Dear TonyU,
Ovatvvon is one of the active members and you should not say him like this.

Well, i really liked the footer of yours.
What a proverb !! Rushi Shroff Rushi@emqube.com
"Life is beautiful."