Hi.

I've a VB6 application, which was based on an Access database. Now we're moving to sqlserver. We use ADODB, and when we use this piece of code:

Dim TbTest as RecordSet

Set TbTest = new Adodb.recordset
TbTest.open "Custom", Curcnxni, adOpenStatic, adLockPessimistic, adCmdTableDirect

TbTest.index = "PrimaryKey"

It throws an error, property not supported. How does sqlserver handles indexes? This kind of index declaration is in many places in the code.

Any help? Thanks in advance!