[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2004-11-03
Medium Priority
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

pique_tech earned 225 total points
ID: 12485156
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.

Accepted Solution

Bat17 earned 525 total points
ID: 12485449
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

834 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