selecting a certain number of records

[Gary.Lowe]

Hi

Does anbody know a way of selecting records from an access database using ADO

e.g

records 300 - 550

[Toot]

What do you mean by "records 300-550"? Are they given an ID of some sort? Or ordered as in the database? What is that order? You could open a recordset and .MoveNext 299 times (v slow)?
More details please!

Toot

[Gary.Lowe]

I have a table with around 30,000 records in.

A vb app will link to this table take the accounts out of it and search an existing billing system and return any values it has found.

Because there are so many records I have set up another table which depending on how many instances of the vb app the user has running splits this table up

i.e.

instance 1 will process records 1 - 300
instance 2 will process records 301 - 600
etc.


I have set all this up but do not know if there is and easy way oo creating a recordset of records 301 - 600

Hope this explains it better.

Gaz

[Crazy D]

Assuming that you have some sort of ID in the database,
recordset.Open "SELECT * FROM MyTable WHERE ID > 300 AND ID < 600 ORDER BY ID"