Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

(223004) - When you import a table into a Microsoft Access project, you may not get the number of records that you expect.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 223004 - Last Review: July 15, 2004 - Revision: 1.1

ACC2000: Table Imported into Microsoft Access Project May Be Missing Records

View products that this article applies to.
This article was previously published under Q223004
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

On This Page

SYMPTOMS

When you import a table into a Microsoft Access project, you may not get the number of records that you expect.
Back to the top

CAUSE

The Default max records setting is too low to import all the records. The default value of the Default max records setting is 10,000.
Back to the top

RESOLUTION

Increase the value of Default max records setting. To do so, follow these steps:
  1. On the Tools menu, click Options.
  2. click the Advanced tab.
  3. In the Default max records box, type a number that is equal to or greater than the number of records in the source table.
Back to the top

MORE INFORMATION

Steps to Reproduce Behavior.

  1. Open the sample database, Northwind.mdb.
  2. Create a table with more than 10,000 records.
  3. Save the table and close Northwind.mdb.
  4. Create a Microsoft Access Project (ADP).
  5. Import the newly created table from Northwind.mdb.
  6. Open the table in Datasheet view.

    Note that the table is limited to 10,000 records.
Back to the top
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbprb kbclientserver KB223004
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Jim Piller - jpiller NOSPAM-AT-NOSPAM wae.cc Report As Irrelevant  
Written: 9/7/2004 8:45 AM
This article helped a great deal. I figured the reason for not seeing past 10,000 was that it was a default limit, but it never occurred to me to try to change it! Thanks for the info, really helps alot! Jim Piller IT Analyst World Almanac Education



Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting