Victor,

If you want to use SQL statements like UPDATE (or views for that matter) to manipulate your data you must have a primary key on every table.

>Sir Tom,
> You said that i 'll issue SQL insert the bulk of the data, as much as i can including the primary key, then use UPDATE table SET (filed1,?val1, and so on..) WHERE primary key=?key to populate the rest of the data.
> Does it mean that i would first issue Insert SQL ,afterwards the remaining fields that are not added on the access table then i will issue Update table so and so WHERE primary key =?key, what if i have no primary key?
> I'm getting the full version of VFP6 will this solve my problem on update/insert w/out limit on fileds that i'm gonna add or update?
>
>thanls a lot and more power.
>