Hi i have a problem

Please help me i tried using crystal reports but when i close the report i cannot compact and repair the database (Access 97). how do i close the database used by my crystal report when i close the report i made...

please help...

Hi mr Roelm,
I think if u pass a connection or a query string to your report by code you must close this connection , or in my case when i close crystal report i can do whatever i want to the Db.
I think is also that if you compact the databese by code u maust pass other paramether for example the name, ecc... for saving the Db and than u must close all the connection in use for the database.

Is occur a specific error , if yes can u put the exact error?
I hope is useful.

Bye  

____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

the error read something like.  "database currently in use"

how do i disconnect from my access db then?

have any code....

Hi,
but the other question is , u are connect eith the program?
If yes u must close all the connection and then compact the db

also the connection related to crystal report.

Bye



____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

Hi,

I think u might not close u r database connection properly in program, I mean it is still open. U can disconnect it by removing related project from ur Taskmanager by pressing Alt+Ctr+Delete.

If ur using ur softwate as a client server application then u also have to remove the same from taskmanager of other terminals.

Closing a query:

First declare and use your query, use a record set to run the query, once you took the data that you required and showed, printed and closed the report, must close it from the events "Terminate" and "Unload" (both of them) using the following code:  
  
if the_record_set's_name.state = 1 then  
the_record_set's_name.close  
end if
unload me

Remember, both "Terminate" and "Unload" events, when you abandon the form, I'm supposing that you have a form behind the report screen.

Try that, works with me, I use it all time