Append query is suddenly not working - urgent!

[stickers]

Hi All,

I have a database with several append queries, one of which has suddenly decided to stop working. The error message I get is that there is a type conversion failure. Can anyone enlighten me as to what this means?

I have a few versions of the db kicking around, and I think it might be an Access problem rather than a DB problem, because when I try to run the query in a previous version that I know was working the last time I opened it, I get the same error coming up.

It also happens on a colleagues machine when I try with previous versions of the db. Could it be something that has happened to all instances of Access in the company?

Hope someone can help!

Thanks, Sarah

 

[Nowell]

maybe there is a problem with the table you are appending to,
have you changed any field data types?
have you tried compacting and repairing the database?

 

[Ecniv]

Check the fields in the source query and destination table. At least one doesn't match and thats your problem.

Vince

 

[stickers]

Hi,

Thanks for replying - no I haven't changed any data types, and the db compacts every time it closes. I additionally did a compact and repair to see if it would help. I had been messing around with some other queries but not the one that it's getting stuck on. Nor do any of the ones I'd changed have any impact on the one that isn't working. I'm totally confused.

Sarah.

 

[JoyInOK]

I would check for null values in the field values of the records you are trying to append. If that is the problem (say, trying to put a null value in a field requiring a date), you can stop the error by using the Nz function.
Expression = Nz([NameOfTheField], ValueToUseIfFieldIsNull)

 

[stickers]

Hi!

Thanks for all the replies. Must admit I overlooked the Null values thing, but (without actually checking) why would the previous version of the db (which had been working fine) suddenly stop working, when I hadn't added any more data to that version?

Sarah