>Michael,
>Yes, I am... i should be - no? I think that the problem has to do with ODBC needing a primary key (yes?)
>
>Thanks,
>Daivd
Yes, for Insert use connection. I've used insert on free tables with no problems. I will have to double check tomorrow at work and make sure they are VFP 5.0 format and not created with FP 2.6 (We use both depending on the application). From your post you said it would work 50% if you zap'ed the file and add a blank record? Sounds like something strange is happening here. My only thoughts are what version of ODBC driver are you using. I guess you could try using an ADO recordset instead of connection just to see if that will work. I am certain that works on VFP 5.0 free tables.
buffer.addnew
buffer("entdate")="6/10/1998"
…load rest of fields
buffer.update
Afraid I haven't seen this specific problem, your code should work (lot of help huh).
Good Luck
Michael McLain