I needed to change some data types and was told there wasn't enough memory or something.
A google solution was
1. Rename the table to tablename_old
2. Copy and paste it to tablename, using the option design mode only
3. Change the datatype in the new empty table
4. Run an Append query to migrate the data
Sounds ok but when I do that I get a worrying message:
Microsoft Access can't append all the records in the append query.
Microsoft Access set 173 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 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.
What does that actually mean?? If I run it, it seems to do it fine. Clicking Help doesn't give much of an explanation. When it says "didn't add 0 Records" does that mean it did add them all. Can I see what 173 fields weren't set to null ? Will it matter ?
Alternately there's a reg setting to adjust. Would that be a better solution ?
A google solution was
1. Rename the table to tablename_old
2. Copy and paste it to tablename, using the option design mode only
3. Change the datatype in the new empty table
4. Run an Append query to migrate the data
Sounds ok but when I do that I get a worrying message:
Microsoft Access can't append all the records in the append query.
Microsoft Access set 173 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 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.
What does that actually mean?? If I run it, it seems to do it fine. Clicking Help doesn't give much of an explanation. When it says "didn't add 0 Records" does that mean it did add them all. Can I see what 173 fields weren't set to null ? Will it matter ?
Alternately there's a reg setting to adjust. Would that be a better solution ?