>>Barry,
>>
>>After you append the data, does TABLEUPDATE() return .F.? If so, use AERROR() to find out what error the ODBC driver returned. That will help diagnose the problem.
>>
>
>HI Josh,
>
>I included the Aerror() routine, however the tablupdate() returned true. Records requiring updating for existing mdb data updated just fine. I just can't APPEND new records. Could this be something to do with the way the Access mdb is configured? Is there a property or something that inhibits additions? Sure could use some help...
So you append the records, then use TABLEUPDATE() and it returns .T., but the records aren't added? That's strange. If you're using table buffering make sure you use the all rows parameter in TABLEUPDATE() (i.e. TABLEUPDATE(1)).