Datasheet

Number
Description
Error Numbers and Descriptions for Microsoft Access 2007
10510
Microsoft Office Access can't append all the records in the append query.@Microsoft Office
Access set |1 field(s) to Null due to a type conversion failure, and it didn't add |2 record(s) to
the table due to key violations, |3 record(s) due to lock violations, and |4 record(s) due to
validation rule violations.Do you want to run the action query anyway?To ignore the
error(s) and run the query, click Yes.For an explanation of the causes of the violations, click
Help.@@21@1@10020@2
10511
Microsoft Office Access can't add all the records in the update or append query.@It set |1
field(s) to Null due to a type conversion failure.A type conversion failure is caused when the
data in one or more fields doesn't match the DataType or FieldSize property in the destination
table. For example, leaving blank fields in a Yes/No field or entering text in a numeric field will
cause this error.Do you want to ignore the errors and run the update or append query
anyway?To ignore the error(s) and run the query, click Yes.@@19@1@922@2
10512
Microsoft Office Access can't delete |2 record(s) in the delete query due to key violations and
|3 record(s) due to lock violations.@Do you want to run this action query anyway?To ignore
the error(s) and run the query, click Yes.For an explanation of the causes of the violations,
click Help.@@21@1@10016@2
10513
The existing | will be deleted before you run the query.@Do you want to continue
anyway?@@20@@@2
10514
You won't be able to undo the changes this action query is about to make to the data in a
linked table or tables.@Do you want to run this action query anyway?@@19@@@2
10515
Microsoft Office Access was unable to update all the records in the update query.@Microsoft
Office Access didn't update |1 field(s) due to a type conversion failure, |2 record(s) due to key
violations, |3 record(s) due to lock violations, and |4 record(s) due to validation rule
violations.For an explanation of the causes of the violations, click Help.@@2@1@10019@1
10516
Microsoft Office Access can't append all the records to the table.@Microsoft Office Access set
|1 field(s) to Null due to a type conversion failure, and it didn't add |2 record(s) due to key
violations, |3 record(s) due to lock violations, and |4 record(s) due to validation rule
violations.For an explanation of the causes of the violations, click Help.@@2@1@10020@1
10517
Microsoft Office Access can't add all the records in the make-table query.@It set |1 field(s) to
Null due to a type conversion failure.A type conversion failure is caused when the data in
one or more fields doesn't match the DataType or FieldSize property in the destination table.
For example, leaving blank fields in a Yes/No field or adding text in numeric field will cause this
error.@@1@1@922@1
10518
Microsoft Office Access can't delete all the records in the delete query.@Microsoft Office
Access didn't delete |2 record(s) due to key violations and |3 record(s) due to lock
violations.For an explanation of the causes of the violation, click Help.@@2@1@10016@1
10519
There isn't enough disk space or memory to undo the data changes this action query is about
to make.@Do you want to run this action query anyway?For information on freeing disk
space or freeing memory, search the Microsoft Windows Help index for 'disk space, freeing' or
'memory, troubleshooting'.@@19@@@2
10520
Do you want to save the changes made to the SQL statement and update the property?@The
RecordSource or RowSource property contained an SQL statement when you invoked the
Query Builder, so the original SQL statement was modified.@To close the Query Builder
without changing the original SQL statement, click No.@13@1@4309@2
10521
Do you want to save the changes made to the query and update the property?@The
RecordSource or RowSource property contained the name of a query when you invoked the
Query Builder, so the original query was modified.@To close the Query Builder without
changing the original query, click No.@13@1@4309@2
10522
You invoked the Query Builder on a table.@Do you want to create a query based on the
table?@@19@@@2
10523
You are about to run a pass-through query that may modify data in your table.@Are you sure
you want to run this type of an SQL query?For information on how to prevent this message
from displaying every time you run an SQL query, click Help.@@21@1@9058@2
Copyright (c) 2008 FMS, Inc.
fmsinc.com
Page 89 of 110