Selecting "Hidden" records
Selecting "Hidden" records
(OP)
My company uses a software that uses DBF's as the backend database format. You have the ability to "Hide" records in the program. When doing queries using ADO they do not show up which is good in most cases. How do I access the "Hidden" records? I have not worked with DBF's in such a long time but from what I remember you need to pack the database in order to actually delete the records. Thanks.
Swi
RE: Selecting "Hidden" records
There aren't any hidden records, just records that aren't getting displayed. The program you use to interface the dbf is limiting the records that are getting displayed. You can use dbase to browse, list or pack out those records if they were marked for deletion. But the interface that you use to access the data is the thing that is controlling the records that you can see. Any utility that can open a dbf file can let you view these records.
Jim C.
RE: Selecting "Hidden" records
Swi
RE: Selecting "Hidden" records
I have never used ADO, don't even know what it is. Is it supposed to allow you to open a DBF file.
Jim C.
RE: Selecting "Hidden" records
CODE
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseServer
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Path & ";Extended Properties=dBASE 5.0;User ID=;Password="
Swi
RE: Selecting "Hidden" records
RE: Selecting "Hidden" records
What your talking about is corruption. I've seen it when browsing files in dbase, but if I switch to FOXPROW it's looks OK. To clean it up, I'll use FOXPROW to create a delimited file, and then zap the original file, and then append from the delimited file back into the original structure, create a new set of indexes and it's clean going forward. If it comes back, then something is causing it to reappear. The end of file marker isn't actually correct, may be two or more end of file markers.
Jim C.