Visual Basic Forum for Visual Basic Programmers VB

[ohno-again]

--------------------------------------------------------------------------------

Hi,

I am using vb6.
the application prints from an access db I use a Data environment and data report to print.

The problem is that I need to close the connection to copy the ms access db that is used to print the reports but the access db that was used to printed (so now the connection is open) previously is still locked (i.e. and opens the microsoft access record-locking infomation file in the same directory) and wont unlock it for some reason.

When I try to do a file copy I get error.

Is there some other way to copy the access db other than filecopy? if not, how do I unlock the access db that is used to print? because

I tried closing the connection ie
dataenvironement.connection.close and also
dataenvironement.recordsource.close
dataenvironement.connection.close
neither worked.

thanks again for any help

thanks for any help

[VB_Developer]

Hi,
Try this code before closing the connection and recordsource.

[VBCode]

set dataenvironment.connection = nothing
set dataenvironment.recordsource = nothing

[/VBCode]

dataenvironement.connection.close and also
dataenvironement.recordsource.close
dataenvironement.connection.close