Hola zangano, intentá esto:
set oConn=Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.Recordset")
oConn.ConnectionString = connectionStr
conn.mode = 3 ' adModeReadWrite
oConn.Open
SQL="SELECT top 6 * FROM noticias ORDER BY id DESC"
rs.open SQL, oConn
If Not rs.BOF And Not rs.EOF Then
Do While Not rs.EOF
Información obtenida de...
aspfaq.com: Why does Access give me 'unspecified error' messages?