Victor,

>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?

Yes.
Insert adds a record. Update replaces exisiting fields in the inserted record. You should have a primary key, or at least a combination of fields that are unique. Without a key how can you identify records for update or even searching?

Logic should be
INSERT INTO ....
TABLEUPDATE()
UPDATE FIELDS... WHERE (some unique clause to identify the inserted record)
TABLEUPDATE()

PS. The UT is us, Universal Thread. The knowledge base is at www.microsoft.com

-Tom