Error -217217887

  • Thread starter Thread starter John Buckett
  • Start date Start date
J

John Buckett

I have a customer using an runtime .mde updating .mdb on
another PC. Once to twice a week the PC with the .mde
gets the following error (my error routine traps the
error):Error -217217887 (Source: Mircosoft Jet Database
Enigen) SQL State 3201) NativeError -535037517). Once the
error has occured the application needs to be shut down
before the customer can start working.

There are no direct hit on MS sites.

Any ideas, I'm pulling my hair out.
 
Search your hard disk for the file:
JETERR40.CHM
It lists the JET error messages.

For 3201, it says:

<quote>
You cannot add or change a record because a related record is required in
table <name>. (Error 3201)
You tried to perform an operation that would have violated referential
integrity rules for related tables. For example, this error occurs if you
try to change or insert a record in the "many" table in a one-to-many
relationship, and that record does not have a related record in the table on
the "one" side.

If you want to add or change the record, first add a record to the "one"
table that contains the same value for the matching field.

</quote>
 
Back
Top