>I've done all that you mentioned, however, what do you do when tableupdate(.t.)
>returns a false. What could be the cause of this. I have defined the keys, made all the necessaty fields "updatable" have checked the send SQL UPDATES checkbox.
>
>Do I need to use the Insert-SQL command? Or with the append blank statement work?
>
>Sandy
Open the MS Access database. On the Tables tab, click on the table in question and open the Table Designer. Make sure there is an ID field that is the unique record identifier.
You are doing everything right that I can see. I had to do this just yesterday and it is just as easy as we have described.
When you get False returned for TableUpdate, issue at the command window:
? aerror(laError)
disp memo like laError*
This will give you more detailed error info.
Mark McCasland
Midlothian, TX USA