OpenRecordset & SQL 2000 data

[Vcscwi]

I'm going through a bit of a learning curve on my first MS Access 2003 app with SQL 2000 data source.

I've worked my way through various index requirements, but now I'm opening the data in VBA via a OpenRecordset.

I found the .Index and .Seek will not work with a OpenRecordset type dbOpenDynaset.

I guess my question is ...Is there a good place to reference sample code of opening a recordset and doing a findfirst or index/seek that works well or quickly. Also how to open a recordset when the table has an Identiy in VBA code?

Thanks for the advice!

 

[RoyVidar]

I found the .Index and .Seek will not work with a OpenRecordset type dbOpenDynaset." - is also mentioned in the help files, on the .Seek method, usually only works in Jet workspace.

Search this site with the keywords openrecordset and findfirst - alternatively, search using your favourite internet search engine

I can't imagine there's any difference in opening a table having identity field or not - the point if you're going to update, is having a unique field, though a timestamp field is often recommended...

Roy-Vidar

 

[PHV]

Search your local drives for files named ado*.chm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886