accessman2
Registered User.
- Local time
- Today, 00:54
- Joined
- Sep 15, 2005
- Messages
- 335
Hi,
I active application role from the SQL Server, then
I open the recordset
rs.open "select .............", conn, adOpenKeyset, adLockReadOnly
and then
Do while Not (rs.BOF or rs.EOF)
conn.Execute("select [path] from
I active application role from the SQL Server, then
I open the recordset
rs.open "select .............", conn, adOpenKeyset, adLockReadOnly
and then
Do while Not (rs.BOF or rs.EOF)
conn.Execute("select [path] from
- where [Name] = 'Tim'").Fields(0).Value
...........
rs.movenext
loop
After the recordset is opened, the conn.Execute doesn't work. But, I cannot close it. how can I fix it?