Hello people
what is the quikest way for your VB program to connect to a table on an an access database (using ADO) and see how many records you have -or the highest id number?
I know there must be somethign like a count. But I need a bit more detailed info.
Thanks in advance

Hi,

To get the number of records you can execute the following statement:

"Select count(id) as numberRecords from TableName"

To get the highest id you can execute the following statement:

"Select max(id) as highestid from TableName"

Hope it helps

Tom.

Yes it did buddy thanks a million.