A
awkusmc
You all have talked about this ... I haven't seen an answer quite matching my
problem.
I have an empty MS Access 2000 DB (structure only) and I am looking to
populate it with old records into the new structure. So it is a conversion.
Autonumber is the key id field(not used in coversion or selection) and I
don't care what MS Access builds for the autonumbered key... and there is no
reference other than it is a place holder to keep all of the information
seperate (no dups).
Heres the SQL that MS Access built;
INSERT INTO tblAAN ( LastName, FirstName, MI, DateReportRecieved, [Date
Report Entered] )
SELECT tblAANold.LastName, tblAANold.FirstName, tblAANold.MI, tblAANold.
DateReportRecieved, tblAANold.[Date Report Entered]
FROM tblAANold;
Here is MS Access's help information:
I'm getting a key violation message.
A key violation occurs if:
You attempt to run a query that appends, deletes, or updates records in a way
that violates the rules of referential integrity for related tables.
Your query attempts to append or update records that contain primary key
values that already exist in the destination table.
If you run such a query, it will not modify the records that cause the key
violation.
To modify records in a way that will violate referential integrity, you can
break the relationship between the affected tables or turn referential
integrity off, and then modify the affected tables one at a time. However,
the resulting data in the two tables may then conflict.
problem.
I have an empty MS Access 2000 DB (structure only) and I am looking to
populate it with old records into the new structure. So it is a conversion.
Autonumber is the key id field(not used in coversion or selection) and I
don't care what MS Access builds for the autonumbered key... and there is no
reference other than it is a place holder to keep all of the information
seperate (no dups).
Heres the SQL that MS Access built;
INSERT INTO tblAAN ( LastName, FirstName, MI, DateReportRecieved, [Date
Report Entered] )
SELECT tblAANold.LastName, tblAANold.FirstName, tblAANold.MI, tblAANold.
DateReportRecieved, tblAANold.[Date Report Entered]
FROM tblAANold;
Here is MS Access's help information:
I'm getting a key violation message.
A key violation occurs if:
You attempt to run a query that appends, deletes, or updates records in a way
that violates the rules of referential integrity for related tables.
Your query attempts to append or update records that contain primary key
values that already exist in the destination table.
If you run such a query, it will not modify the records that cause the key
violation.
To modify records in a way that will violate referential integrity, you can
break the relationship between the affected tables or turn referential
integrity off, and then modify the affected tables one at a time. However,
the resulting data in the two tables may then conflict.