On Tue, 06 Sep 2005 17:57:18 +0300, Vladi <vl******************@ktl.fi> wrote:
Experience is highly requested.
I can't find solution for the following problem:
I am making VBA code for moving/modifying data from "old" tables into
"new" ones. In fact, this is part of the upgrade module for a data entry
product. In the existing tables at customers' site there could be some
values in some fields, which violate validation rules. I have to copy
them as they are, in the new tables, in the fields having the same
validation rule.
I can't do this, at line with update - the error 3316 is coming.
Hi
I assume this is table-level validation.
You will have temporarily change the ValidationRule property for the tabledef
or field object while doing the importing (this is possible provided it is a non-
attached JET table) and then change it back again - I believe that if the latter
is done in codetthe database will not validate existing data though it
may tell the user this or ask whether it is required, you would need to test it.
It would be better if you could take some remedial action during the import to
correct errors or put them in some other table.