Anyone used the Access.Application object ?

I have had to use it to execute a macro in an .mdb file.

using....

<pre id=code><font face=courier size=2 id=code>
&lt;%
set access = server.createobject("Access.Application"
access.opencurrentdatabase "c:\pathtomy.mdb"
access.docmd.runmacro "mcrMyMacro"
access.quit acQuitSaveNone
set access = nothing
%&gt;
</font id=code></pre id=code>

this works fine however it is not releasing the database.....

the .ldb lock file will not go away, even if you delete manually, i get the file in use error....

is there another method for this object that will release it completely?

Cheers In Advance
Leed

:: Son, im Thirty.... ::

Edited by - leed on 27 Nov 2002 12:47:10

Edited by - leed on 27 Nov 2002 12:47:42