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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 15 Mar 2007 14:45 GMT

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.

Reply to this Message

Allen Browne - 15 Mar 2007 16:33 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am trying to create a link table from a database over a LAN which
>contains
[quoted text clipped - 5 lines]
> the
> database to link up with the table? I am using Microsoft Office 2003.

Reply to this Message