>>
>>Make a connection string and put something like this in it:
>>
>>DSN=BSD;DBQ=C:\EANDK\VB\BUSDEV.MDB
>>
>>Where BSD is the ODBC data source and the c:\... is the path to your database.
> Hi Josh - it's me again. THe above code worked like a charm. Again - much thanks.
>
>Remember the not being able to append problem? Well, it works now for one of the two tables in the mdb. The Header file is perfect, and the detail view contains the selected data. However, after running the Tableupdate, it returned a .F. without an error. The Aerror() handling routine did not fire. How can I find out why it isn't updating? I put in code for EACH field to check for NULL characters, so I don't think that's the problem. Are there any other "quirks" that may be causing this?
>
>Again, thanks for your help.
>
>Barry

Barry,

When TABLEUPDATE returns .F. no error is triggered. You use VFP's AERROR() function to determine what error was returned by the ODBC driver.