Type Conversion Failure

[beefyme]

Hi there,

Basically my update queries and my append queries have all of a sudden
stopped working! They have been working before (few days ago) and due to
something have stopped working.

The error i get for the queries are:

"Name of Database" didn't update/append x many records, due to a type
conversion failure. 0 records due to key violotions, 0 records due to lock
violations, and 0 reords due to validation rule violations.

How can i solve this?

Any ideas would be great, and please can you explain everything in full and
step by step.

Thanks! Greatly appreciated.

 

[John Vinson]

Any ideas would be great, and please can you explain everything in full and
step by step.

Could you please help us by doing the same - i.e. posting the SQL view
of the query?

John W. Vinson[MVP]

 

[Tom Wickerath]

If you are willing to send me a compacted and zipped copy of your database, I
will take a look at this issue for you. You can substituted dummy data for
your real data, if there is any sensitive information. Just verify that you
can duplicate the error in a modified copy of your database.

If you are interested, send me a private e-mail message with a valid
reply-to address. My e-mail address is available at the bottom of the
contributor's page indicated below.

Please do not post your e-mail address (or mine) to a newsgroup reply. Doing
so will only attract the unwanted attention of spammers.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[beefyme]

SQL VIEW IS :

INSERT INTO tblArchiveStaff_Shift ( StaffID, ShiftID, ShiftTime,
WeekCommencing )
SELECT tblStaff_Shift.StaffID, tblStaff_Shift.ShiftID,
tblStaff_Shift.ShiftTime, tblStaff_Shift.WeekCommencing
FROM tblStaff_Shift;

Very simple.

Thanks for your reply, hope u can help.