I am familar with ASP pages and reading & writing data to Access
databases & SQL Tables.  So I am okay with writing ASP, writing
connection strings to Access tables.  I can get this working.

But now I want to read a table within my access database called CMEINF.
But CMEINF is actually linked to a foxpro table.

I tried it a few ways:

1) Go into the Access db, Link the Foxpro table by selecting: Get
External Data, Link Tables, and select the Microsoft Foxpro type.  The
DBF file is stored on a different server and path.  When I do this, I
get:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not find installable
ISAM.

/physician/phycme/testdb.asp, line 50

2) I copy the CMEINF.* files to the same location as my ASP.  I then
link it the same way as described in #1, but this time the Foxpro table
is on the webserver, with my ASP.

I get the same error as in #1.

3) I setup a System DNS using the "Microsoft Foxpro VFP Driver (*.dbf)"
option.  It's called "CME)Data".  It's a "Free Table directory" database
type and I point it to the original directory that CMEINF exists in (on
a different server). I then link the CMEINF.DBF file in my Access
database by selecting the ODBC.  When I do this, and try to access the
table in my ASP I get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'CME_Data'
failed.

/physician/phycme/testdb.asp, line 50

4) I do the same thing in #3 but I change my DSN to point to the
directory where my ASP script it on the web server (because I copied the
CMEINF.* Foxpro files to this directory).  And I get the same error.

Anyone got any thoughts on want to do for any of these ways?

I didn't think it was neccassary to post my code since it's changing for
each of these ways.  However, my connection string is correct because I
can query a regular table in my Access database.  It's when I try to
open a recordset to one of these Foxpro tables is when I am having
problems.

Thanks
-Colin

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!