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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Table Cant Delete Record 2
importing a linked table from one file to another as a local table 3
Linked Table not showing all data 6
link goes crazy in 2010 works fine in 2003 1
Linking Access to selected fields in a large external table 1
Break the linked tables 6
Oracle linked tables 3
Link Table 2

Back
Top