Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Validation Rule Violation with Update Query in Access 2000

267 views
Skip to first unread message

Marjorie Stein

unread,
May 8, 2002, 6:52:24 PM5/8/02
to
Dear Folks
I'm trying to perform an update query in Access 2000 between two
tables and I receive a message that records cannot be updated due to
validation rule violations.

The data-types & field sizes between updating fields are identical. No
field has any validation rules. The tables have no validation rules.
The table I'm updating TO has has an auto-number primary key field,
but I'm not trying to update that field. The table I'm updating FROM
also has a "dummy" primary key field, which I'm not using in the
query. (I also tried the query without this field...no luck).

Thanks in advance for any recommendations!
Marjorie

John Vinson

unread,
May 8, 2002, 7:49:04 PM5/8/02
to
On 8 May 2002 15:52:24 -0700, mst...@geopraxis.com (Marjorie Stein)
wrote:

>Dear Folks
>I'm trying to perform an update query in Access 2000 between two
>tables and I receive a message that records cannot be updated due to
>validation rule violations.

This error message can come from a variety of rules other than just
the validation-rule property:

- Required fields being left NULL
- Adding fields which violate relational integrity to another table
- Table validation rules being violated (not just field rules)

Perhaps you could post the SQL of the query.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Marjorie Stein

unread,
May 10, 2002, 12:36:01 PM5/10/02
to
Hi John
Thanks so much for your response to my problem.
1. I doubled-checked both tables, and neither have any required
fields.
2. I am not updating the two fields that have relationships to other
tables in the database.
3. Neither of the tables have validation rules established.

Here is the SQL statement for the query:

UPDATE Contacts INNER JOIN [Contacts From Outlook] ON
Contacts.DisplayName = [Contacts From Outlook].DisplayName SET
Contacts.Company = [Contacts From Outlook].[Company], Contacts.Title =
[Contacts From Outlook].[Title], Contacts.JobTitle = [Contacts From
Outlook].[JobTitle], Contacts.Department = [Contacts From
Outlook].[Department];

Thanks again in advance for any help.
-Marjorie


John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message news:<g7ejdu072k6jqim4r...@4ax.com>...

shiela

unread,
Jul 2, 2002, 6:08:34 AM7/2/02
to
hi!

i have encountered weird errors like what you have encountered! I just
close the application and start over again and it works. I don't know
why it happens but my solution works! Or create a new query with the
same feilds.

--
Posted via dBforums
http://dbforums.com

0 new messages