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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is wrong with this? 1
Not Responding - Open Recordset 6
Not Responding .AddNew Record ADP 9
Recordset question in access? 5
Update table with VBA 3
Problem with .Update 4
ado issue 0
ADO Connection 2

Top