Oops

If you not see the Immediate window
Press Ctrl g




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"sam" wrote in message ...
Thanks for the help ron,

Do you know where I could find this number associations? and how to use them
here?

Thanks in advance

"Ron de Bruin" wrote:

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