vb6 to Access using reports err msg "object already open"

[shankark]

Hai All,
while working in VB 6 connecting to Access using Data Environment i encounter the following problem. For the first time, while printing the reports no problem. But for the 2nd time, it tells "Object already open."

Looking forward for a solution at the earliest,

thx, regds, Shankar K.

 

[vijayKumartaduri]

hai,
Close the open objects after complition of that object job.
and reopen that object when u need it.

i think u know how to close that object.
'object.close

i hope this info is useful to u..if not leave it out.

see you

 

[Guest_imported]

hi shankar,
This message comes because you haven't closed the
recordset object.Either you can close the recordset object
with statement

rs.close

or you can check the state of recordset before opening it,

if rs.state<>adstateopen then
   rs.open
endif

hope it is works in your case
with regards
saritha