Duplicating records

[Jeff]

I have suddenly started having a problem with the DBRW. It has started
repeating records. Let's say that I only have one record in the table in the
DB... It might return that same record 2 times.
I dont know what happened to cause this, as nothign has changed. Anyone ever
come across this?
Jeff

 

[Jim Buyens]

Have you opened the database in Access and verified that
only one record is present?

If that doesn't resolve the problem, rerun the DRW and on
page 2 click Custom Query and Edit. Then, copy the
contents of the SQL Statement box and post them to this
thread.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jeff]

umm.. Let's just say user error and leave it at that.. mmky??

 

[Jim Buyens]

OK, I take it you've narrowed down the problem, and it was occurring
somewhere between the keyboard and the seat cushion.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jeff]

ROFL... yea... how did you know. There was a second recort set in the DB
table.... and I thought there was only 1. Hence the problem....