Question Executing statement from VBA Code

[itsmedd]

Bob, i am getting the same error message with no luck.

 

[itsmedd]

Bob, Will it make difference in the way i am executing this statement with Recordset.

rs.CursorLocation = adUseClient
rs.Open strSQL, rsconn, adOpenKeyset, adLockPessimistic

 

[boblarson]

Well, I'm at a loss and the LAST piece of help I can give is for you to go through EACH field and make sure that the data going in is correct. If you have Text going into a field you will need to probably encapsulate with single quotes; if you have dates going in you have to use the octothorpe (#) and numbers don't need to be encapsulated. Other than that, I think we're stuck because I can't see your SQL database and your Access one and play with it to see what is up. That would be my last way I, personally, could do anything.

 

[boblarson]

Bob, Will it make difference in the way i am executing this statement with Recordset.

rs.CursorLocation = adUseClient
rs.Open strSQL, rsconn, adOpenKeyset, adLockPessimistic

I don't know - But since you aren't updating anything you should not need adLockPessimistic, just use adLockOptimistic and you could use a Static recordset instead of Keyset.