Database only returns 1 record from Access 2000 DB

<i><b>Originally posted by : Shane Reynolds (Shane.Reynolds@Ntlworld.com)</b></i><br /><br />I am having major problems getting records back from an Access 2000 DB. I am using PWS on a Win'98 box but can only seem to ever get one record out of the database. The strange thing is identical code on an NT 4 box works fine getting all records. <br /><br />Any help greatly appreciated, this is driving me up the wall...<br /><br />

<i><b>Originally posted by : jerry Scannell (JScannell1@home.com)</b></i><br /><br /><br /><br />------------<br />Shane Reynolds at 3/25/2001 6:40:42 AM<br /><br /><br />I am having major problems getting records back from an Access 2000 DB. I am using PWS on a Win'98 box but can only seem to ever get one record out of the database. The strange thing is identical code on an NT 4 box works fine getting all records. <br /><br />Any help greatly appreciated, this is driving me up the wall...<br /><br /><br />Please provide me with sample code. I am using Access 2000 and have successfully used it with PWS and then immediately use in on IIS under Windows 2000.<br /><br />

does the query contain a "TOP" statement? Is the query in Access so that the "Top Values" param is set? Is it a stored proc that contains "ROWCOUNT 1"?