I use FoxPro dbf files in Access, using the link option (under External Data). Suddenly, there are records that I cannot view in the Access file. For example, the record count in the dbf file is 18842, but when the file is opened in Access, the count is 18771. The missing records are not the last or the first. I've indexed the dbf file and run compact & repair on the Access db, removed and relinked the dbf file. :banghead:
Any ideas?
Any ideas?
