FK Constraint Violation upon INSERT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have an adp application that was automatically generated upon an upsizing
of an Access database to SQL Server 2000.

For the most part everything went remarkably well. However, I just
encountered an error when I tried to add a new record.

The error is: INSERT Statement conflicted with Foreign Key constraint
"solution_FK00" The conflict occurred in database x, table "question"
column "Questionid"

This error occus when I am trying to insert a recod in the parent table;
like inserting a record in the Orders table without a correposnding record
in Order_Detail table..

Normally this would not cause a referential integrity problem. So I am
unclear on why I am getting the error.





.

Relevant Pages

  • tool to re-reference forms after usizing?
    ... I am in the process of upsizing an access database to sql server. ... report, ...
    (microsoft.public.access.conversion)
  • Re: EMPTY TABLE AFTER UPSIZING TO SQL
    ... Access instead of the Upsizing Wizard: ... Sylvain Lafontaine, ing. ... I have an Access database that has a table which cannot be upsized to ... SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to convert my MS Back -End Database To MS SQL Server 2K?
    ... Now I have to try your inputs and have to be oriented to the SQL Server ... But after upsizing, you still need to go through each ... >you need to re-specify primary key for each table. ... >your FE in MS Access *.adp project. ...
    (microsoft.public.access.adp.sqlserver)
  • Problem2 after upsizing
    ... I've done the upsizing of my Access database with the SSMA wizard of Access. ... (Linked tables, not ADP) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with Converting Access query to SQL Stored procedure Please!
    ... parenthesis at the end of the Where clause. ... prefix before the name of the procedure, as ADP ... >>I am converting an access database to SQL server and editing the active ...
    (microsoft.public.access.adp.sqlserver)