barancea
August 1st, 2001, 12:06 PM
I have a problem with closing the connection after showing a data report.
Here is my code:
'now there is no connection to database(the file Database.ldb does not exist)
deX.cntX.Open 'opens a connection, cntX, from a data environement, deX
deX.cmdX parameterX 'opens a command object, cmdX, with parameters, used
'in the report rptX
rptX.Show 'shows the report
deX.rscmdX.Close 'closes the recordset of the command cmdX
deX.cntX.Close 'and the connection cntX
'now the connection to the database is still open (the file Database.ldb still exists)
What is to be done to close this connection considering that it's possible to need to overwrite the database Database.mdb?
Thanks!
Nelly
barancea@email.ro
Here is my code:
'now there is no connection to database(the file Database.ldb does not exist)
deX.cntX.Open 'opens a connection, cntX, from a data environement, deX
deX.cmdX parameterX 'opens a command object, cmdX, with parameters, used
'in the report rptX
rptX.Show 'shows the report
deX.rscmdX.Close 'closes the recordset of the command cmdX
deX.cntX.Close 'and the connection cntX
'now the connection to the database is still open (the file Database.ldb still exists)
What is to be done to close this connection considering that it's possible to need to overwrite the database Database.mdb?
Thanks!
Nelly
barancea@email.ro