Failed getting Rowst(s) from current data source 1

[aalmeida]

I have a datareport that retrieves data from an MS Access 2k table using Jet 4.
The problem I'm facing is:
The datareport1 runs fine at the fisrt time you call it
The second time you call it it gives the following error message.
Microsoft Visual Basic
Run-Time Error '8577':
Failed getting Rowst(s) from current data source.

Any help is welcome
Thanks

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[aata]

did you close the connection in the terminate event of the data report? you need to load the dataenvironment as "load dataenvironment1" before you give "report1.show" and you need to unload it in the terminate event of the data report as

Private Sub DataReport_Terminate()
Unload DataEnvironment1
End Sub

did you try this?

 

[aalmeida]

aata,
That did the trick thanks very much!!

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"