new Connection

[rishi_375]

Hi,
Using ADO how can i open access connection and handled transction in that code.

I use below string but it will give me error message
while i'm commit or rollback trans.

CurrentProject.Connection.BeginTrans

rsCosts.Open "select * from Costs", CurrentProject.Connection, adOpenStatic, adLockOptimistic

Pl help me.

 

[Kevin_S]

Use the search function on this forum to search for "ADO Connection", "Connection String","Create Recordset".... These should get you all the help you could ask for....

HTH,
Kev