Table problems

[TimJr]

I'm having trouble opening tables that I create from a copy of a blank table.
The blank table is a table that contains no data.
I copy the blank table to a new table (ie. 06242003.dbf).
This works fine.
I then try to open the table and get the following error:
"ODBC driver does not support requested property"

The code is as follows:

Dim objRec2
Set objRec2=Server.CreateObject("ADODB.Recordset&quot
objRec2.Open strDataFile, strConnect, adOpenStatic, adLockOptimistic, adCmdtable


strDatafile is the path and name of the table without the extension(ie. C:\....\06242003)
I get my error on the objRec2.Open line.

I know the ODBC drivers are setup properly.

I'm new to ASP so maybe I'm doing something stupid.
Any help???????????

 

[TimJr]

Never mind!

Rookie mistake.
I included the path name in the table name in the OPEN statement.
The path is determined by the connection string.

Sorry for wasting your time!