MyODCB 3.51 and DSN-Less Connection

[asfaw]

I am using Micorosoft Access 2000 as a fornt end and MySQL as a back end.

I hope someone may be help me to clarify the following:

Q.1. Where do I specify cursor location to be adUseClient

Q.2. Where do I specify cursor type to be adOpenStatic

Q.3. Where do I specify lock types to be adLockOptimistic

An example would be helpful.

Thank you,

Asfaw

 

[Bastien]

1. after the connection object is created

2. & 3. in the rs command line

set conn = server.createobject("adodb.connection")
rs.cursor = adUseClient

sql = "select * from ..."


set rs = server.createobject("adodb.recordset")

rs.open sql, adOpenStatic,adLockOptimistic

Bastien

Cat, the other other white meat

 

[asfaw]

Thank you very much.