>>This is very strange. And you're SURE that TABLEUPDATE() is returning .T.? One think you should do is make sure that any dates aren't empty. If you have an empty date you need to replace it with NULL because Access doesn't understand blank dates. Still, if this were the problem I would expect TABLEUPDATE() to return .F.
>
>
>Halleujah!!! Thanks to you the Append problem appears to be solved. I would have never known that empty dates would cause this condition. I removed the date replacements from the code to test and it appended just fine. If you're ever down in the Sarasota area, look me up and I'll buy you a dinner.
>
>Thanks again.
>
>Barry
Barry,
Glad I could help. If Duke continues their winning ways I'll be in St. Pete next weekend, but I won't hold you to the dinner offer. You'd have to buy dinner for my wife and her family, too which could get a bit pricey :)
Actually, if you knew of a hotel or B&B in the area with a few free rooms next weekend I'd be eternally grateful (fat chance, I know, but I had to ask).