Missing records in Access 2000 link to dbase table.
Big problems here at work because we discovered that when you use MS Access to link to a dbase table, you don't get all the records expected. This is because the dbase table in question (reccatch) was indexed with a unique index. When Access encounters this it only grabs those records that are unique in the field with the index. So our dbase table had a unique index on the Lake ID (D.O.W. number) field even though there are a lot of cases where there are several records with the same Lake ID (D.O.W. number) . Right now we have fisheries biologists all over the state using Access to get into their dbase tables and there is no warning to tell them that they are not getting all the records they expect. There is more information here. Of course, this will all be fixed when we get the new program up and running in by the drop dead date of February 12, 2055.
11:55:28 AM 
|
