>I am attempting to update an ACCESS table. When I try to close the table I get error 1492 - "No key columns are specified for the update table "setups". Use the KeyFieldList property of the cursor." even though with the debugger open GetCursorProperty(KeyfieldList,ttable)shows that I have set a key field and the field is actually a key field in the access table. Something else is happening. Can anyone tell me whats going on? Thanks. This project is due today.
In case there was a typo above, what do you get from the following:
CursorGetProp('KeyfieldList', tTable)
CursorGetProp('UpdatableFieldList', tTable)
CursorGetProp('UpdateType', tTable)
CursorGetProp('SendUpdates', tTable)
Do any field names have spaces in them? If so this could be a problem. Wrap them in full quotes.
Mark McCasland
Midlothian, TX USA