Hey all,
I live in the .net world and have a job to convert some VB6 code that uses DAO databases and recordsets.

This is the code...
Code:
Set ds2 = db2.OpenRecordset("Schedule")
ds2.Index = "KeyDateEmp"
ds2.Seek ">=", xDate
db2 is an established connection to an Access 95 format database at c:\pathToAccess\myDB.mdf.

The first line I get, but I don't get the index and seek because I don't have a column in the Schedule table named KeyDateEmp. I assumed the index and seek work together to set up the equivalent of an SQL command.

Can some explain how the Index and seek work on and open recordset?

Name: Untitled.png Views: 282 Size: 17.1 KB