Hope all you Americans are enjoying your Memorial Day..
Well anyway my problem that's arised is the following.
I'm using Access 2003, and with my append query I'm writing it's not exactly appending.
What I'm doing is taking information from a table called Service Hours, and trying to append it to a linked table with the exact same information in it. So I know it's got nothing to do with the information on either table not matching up.
It cannot append all the records it's set 0 field(s) to Null due to a type conversion failure and didn't add 1 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.
Now before ya ask..yes all the data types are the same, there shouldn't be any difference between any of the information. None of the records I'm trying to append are autonumbers or a Primary Key so I don't understand where exactly things are going wrong. So if anyone can help out that'd be great.
everything seems to be in order for it to allow me to append..I'll toss up a sample DB with just those two tables linked..and the query as well..let ya have a look through it see if ya can figure it out..cause I'm beyond baffled by this lol
the reason for this is because here we have our service guys who are out on the road almost every week for 2-3 days at a time or more..so..they update a local version of the said databases, and come back to the office to insert their data into the server version back at the office.
So what we're trying to do is have it so instead of enterting in their data twice(once on their copy, and then again when they get back) they click a button on a form, and get it to update/append the new data.