General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>You don't. Foxpro's indexes worrk with Foxpro not with Access.
>>
>>Ron
>
>i remember seeing a debate/thread about this ...
>and the conclusion was that when properly configured one could access data quickly from foxpro databases in ODBC if the indexes were set up properly.
>Not that Access would actually "open up" the CDX but that the ODBC "DSN" had to be set up correctly and you had to set up the SQL-SELECT statements properly in Access (or whatever front end tool you were using)
>
>
>>
>>>I have set up an ODBC connection allowing Access97 to use a foxpro database.
>>>
>>>How do I take advantage of the indexes in the Foxpro database to speed up searches in Access97?
Dave,
actually Access will use Fox index if you link free fox table (.dbf) to Acccess database. I remember linking really big fox table (2.8 miliion rec), but I am not sure that it works with the table from database. I guess it does not. Don't know how ODBC driver will use fox index.
Thanks,
Oleg
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only