COMPLETELY CLOSING AN MDB CONNECTION

[sebpas]

I'm trying to completely close an mdb file that was open previously in the same application using ADO. I do a close on it and set xx=nothing but i still see the ldb file present, meaning that the file is still open by the program.
Is there a way to close it completely without terminating the program? I want to be able to compress the mdb even if people have done transaction on it in the same session.
Any help will be very appreciated.

 

[Sawatzky]

dear sebpas,

maybe you dim your ado like this:

dim adocon as new adodb.connection

if so try this:

dim adocon as adodb.connection
set adocon = new adodb.connection



HTH

regards Astrid