>I have a remote view which is based on the 26 fields of MSACCESS. from there Ive created a form with a grid and 26 textboxes on it. the grids recordsource is based on the alias of the view and controlsource of the textboxes is based on the view.fieldname. In the form i have a button which has a command like this =tableupdate 1,.t.,y2k to update the cursor then the datasource. but when i tried to run again the form still i get the same data and no updating happens in the process. Ive tried diff. approaches on views update criteria but still no effect at all. Please help me it gives me a terrible headache for this thing. I dont want to resort using msaccess.
May be a stupid question, but do you have 'Send SQL Updates' checked in the view designer?
Are you using the following syntax (your message was unclear)?
TABLUPDATE('MyView',.T.,.T.)
I have never had any problems connecting to Access and am not aware of any secret settings for getting it to accept updates.
Erik Moore
Clientelligence