why doesn't all of the records show up in a link or import table?

K

Ken

I am trying to create a link table from a database over a LAN which contains
approximately 60,000 records. When I create the link table and view it only
about 19,000 records are showing up in the table. I tried just importing the
data into a new table but got the same results. How do I get the rest of the
database to link up with the table? I am using Microsoft Office 2003.
 
A

Allen Browne

Try opening the back end database directly, and giving it a compact/repair:
Tools | Database Utilities | Compact/Repair.

That should fix it if the problem is caused by a bad index.
 
Top