Open ODBC connection as Static

From: Kenneth (kennethNOSPAM_at_pardue.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 10:54:02 -0500

I'm trying to get a simple, one line way to return the total number of
rows in an Access database opened via ODBC. Currently, it returns the
dreaded "-1" result because it is not a static cursor. How can I open
the database with a static cursor so as that odbc_num_rows returns a
proper result?

Many thanks,
Kenneth