Bad RecordSet or Bad table ???

M

Michael

I have a simple query on a simple table ....
There are no duplicate records in the database - visually
checked in side Access yet the following query reports
some records more than once ...

aSSQL = "SELECT * FROM rte_steps WHERE rte_id_num =" &
rid & " ORDER BY rte_seq ASC"

Set nRs = Server.CreateObject("ADODB.recordset")
Set nRs.ActiveConnection = oConn
nRs.Source = aSSQL
nRs.LockType = 3

nRs.Open

response.write(scratch)


do While Not nRs.EOF

/// +++++ Print a bunch of stuff here ++++

nRs.MoveNext

Loop

nRs.Close


Is it a corrupted table or a problem with the locktype
value for theis query ????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset problem w/ Access 2000 1
adOpenStatic Recordset still changing my table 5
Path reference for (say) mydb.mdb in myfile.asp ? 2
Make table from recordset 2
use lbox recordset property w/ ado memory recordset? 2
how use listbox recordset property with ado memory recordset ? 0
Unable to read DB - Locked Link Table 1
to show a recordset as table 7

Top