Linking FoxPro Tables to MS Access - Missing Records

[EBox]

Hi:

I am linking my MS Access 2003 app to a FoxPro database. I have a successful ODBC connection, and can link to all tables.

However, when linking to one particular table, I am unable to view all records. I am told by the FoxPro data administrator that the records I cannot see are marked as deleted (but still exist) in FoxPro, and I was wondering if this is the reason that Access can't "see" them.

Does anyone have any thoughts or ideas?

Much appreciated-
EBox

 

[PHV]

It's normal behaviour for an ODBC driver to not select deleted records ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886