Yea, but it's a very ugly solution. If you iterate though all the rows and count them as you iterate through, you will end up with a row count.

You can then move the pointer back to the first row.

    How do I go about getting the ODBC RecordCount when using Access database? I have a client that HAS to use Access, and the only function I have found odbc_num_rows() doesn't work with Access ... is there a way to get odbc_result_all to give me the number of rows without printing them?

      Write a Reply...