Error 2101-The setting you entered isn't valid for this property

Posted on 2004-11-03
Last Modified: 2008-01-09
This one is weird;  I hope someone has seen it before.

I am reading a linked file with about 40,000 records and then adding records to several tables that are local to Access.  I am doing this for five different sites, but the file structure I am writing to is identical in each case, and appropirate records are selected for each site.

In each case, I am reading all 40,000 records, in site number order.

Site 1 load runs fine.  The bulk of the records are at the beginning.

Site 2 load runs fine.  The bulk of the records are in the first half of source file.

Sites 3, 4, and 5 all get an error when the load is 99% complete.  Of course, all of these records are in the last half of the source file.

The error I get is "2101: The setting you entered isn't valid for this property".

By the time I get the error, I have already run through the sections of code that generate this error thousands of times.  The failure is happening in a progress meter program Property Let module.

I have tried the decompile suggestion with no success.

For various reasons, I want to read the entire source file each time, but if I am desperate, I may try to decrease the number of records to just the site involved, although that is probably a long shot anyway.  An easy, reasonable work-around would be fine.  I haven't tried reading the source file in descending order, for example.
Question by:dingmaeh
    LVL 12

    Assisted Solution

    I think your idea is the right one, as unpleasant as it sounds.  Try reading half of one of the sets of records which cause the failure, then if it fails, try reading half of those, etc., until you narrow down to where the source of the error is.  Then examine the "defective" data to try to understand what's wrong and more importantly, how to fix it before attempting to import.
    LVL 9

    Accepted Solution

    Might be worth checking out data types as an integer only goes up to 32,767 and you are just breaking it.
    do you have some sort of counter running that you could use to check which record number it actualy bombs out on?


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now