Datasheet

Microsoft Access
E3
Microsoft Access can't append all the records in the append query.
rliCrOSOft
field(s) to rquii due to a tpe conersion failure, and it didn't add 121 record(s) to the table
due to key .ic'latic'ris U record(s) due to lock violations, and 0 record(s) dije to ...ealidation rule violations.
.:.?ou want to run the action query anykNay?
To ignore the error(s) and run the query click Yes.
For an explanation of the causes of the violations, click Help.
%Les :I
uo
Help
49
Manual
Data Processing in MS Access and Final Storage into the NBD
Step D14: Click Yes.
A message box similar to the one below follows.
Step D15: Click Yes.
This steps finalizes the data processing in MS Access. The destination NBD table is by its primary key settings
protected against duplicate records. If a certain record would be added for the second time, the following message
box shows up. It indicates that the processing operation is carried out but that any double rows will not be added due
to ‘key violations’. Click Yes to perform the query to process the genuinely new data.
In order to visualize the final results stored/appended in the NBD destination table “AWS Meteo_Hourly Data”,
locate this table in the appropriate NBD folder and file (consult chapter 6.2 for this purpose) and open the table in
the database view.
Step D16: Highlight the “AWS Meteo_Hourly Data” table from the NBD file “Daily Clim Uganda.mdb”.