Noreene Patrick
Registered User.
- Local time
- Today, 01:55
- Joined
- Jul 18, 2002
- Messages
- 223
I have been using a database for several months that was designed by someone else and worked perfectly until lately. I enter the data and then do an append query (which like I said has always worked).
But, now I get this message that say:
Cannot append these records because ...set 0 field(s) to null due to a type conversion failure and didn't add 9 records to the table due to key violations.
Now, 9 records was all I put in and sometimes I can put in records and it will only append 1 or 2 of those records and no more.
I cannot figure anything that I am doing that is different to cause this failure.
Could you please give me suggestions on what to look for in solving this problem?
Thanks to you in advance.
But, now I get this message that say:
Cannot append these records because ...set 0 field(s) to null due to a type conversion failure and didn't add 9 records to the table due to key violations.
Now, 9 records was all I put in and sometimes I can put in records and it will only append 1 or 2 of those records and no more.
I cannot figure anything that I am doing that is different to cause this failure.
Could you please give me suggestions on what to look for in solving this problem?
Thanks to you in advance.