Hi Sam
You must use the number for
adOpenKeyset
adLockOptimistic
....................
Set a reference to activex data objects and enter this in the Immediate window in the VBA editor
? adOpenKeyset
After you press enter you see the number
Maybe this page will help
http://www.rondebruin.nl/ado.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"sam" wrote in message ...
Hi All,
I am getting an error on this line, when I used late binding.
rs.Open "Sheet1", cn, adOpenKeyset, adLockOptimistic, adCmdTable
Am I missing something or doing something wrong? I am using ADO to connect.
Thanks in advance