I don't know how to see the deleted records using the Dbase driver, but if want you could use the Visual FoxPro Driver and build your connect string like so:
Hope this helps.Code:strConnect = "DSN=Visual FoxPro Tables;UID=;" strConnect = strConnect & "PWD=;SourceDB=f:\users\mdoss\pdcdata\data;" strConnect = strConnect & "SourceType=DBF;Exclusive=No;" strConnect = strConnect & "BackgroundFetch=Yes;" strConnect = strConnect & "Collate=Machine;Null=Yes;Deleted=No;" cnConn.Open strConnect
[Edited by dcarlson on 12-07-2000 at 11:49 AM]




Reply With Quote