I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.
You can customize your Microsoft Access database by calculating values, setting search criteria and formatting data fields with expressions. Syntax is the kind of information and order of information ...
I've got an Access 2003 database linked to a SQL Server 2000 database. <BR><BR>In SQL Server (Enterprise Manager) - the field is listed as:<BR>Data Type: text, Length: 16, Allow Nulls = Yes<BR><BR>In ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback