What is wrong with this line?

J

Josh Grameson

Using Access 2K which as tables in ms sql 2K that it links to.

in the code I have this:

Set rstDeliveryHeader = New ADODB.recordSet
rstDeliveryHeader.Open "[tblDeliveryHeader]", CurrentProject.Connection,
adOpenKeyset, adLockOptimistic
rstDeliveryHeader.AddNew

and I'm getting an erron on the last line (AddNew).

What am I doing wrong?
 
Top