I guess the COM wanted the connection open:-).
There used to be a guy on this board, JVP, but he is no longer participating. However, he has written some [very good] white papers:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.aspThere is a RecordSet property called
Editmode. It might help you a bit if you read JVP's paper at the above URL.
Who is "rush/html/Admin_UserEdit.asp"? Is this your COM, or a vendor's?
You migt try setting step on, and assure yourself that your references and data types are as they should be.
>Terry,
>Thanks for the suggestion.
>
>I placed this code in the page,...
>
>IF Recordset1.ActiveConnection.State > 0
> Recordset1.ActiveConnection.Close
>ENDIF
>
>just Before the DLL call, and get this error:...
>
>Microsoft VBScript runtime error '800a01a8'
>Object required: ''
>/rush/html/Admin_UserEdit.asp, line 160
>
>So I placed it at the End of the page. THAT error goes away, but I still get the Access Denied error.
>
>Is there something happening, perhaps, with the MTDLL not releasing the table? I've shotgunned ALL my Procs with CLOSE TABLE ALL CLOSE DATABASES ALL and CLOSE ALL before the RETURN statements, but No change.
>
>I've looked in numerous Websites as well as my local MSDN help files on ADO,ASP,VBscript, and in VFP on COM and Automation Servers.
>
>I'm pretty confused at this point as to how to proceed.
You'll get it - something is missing - and it will eventually bubble it's way up. You're sure it's not a firewall issue?
>
>Thanks for your help.
>
>David
>
>David
Imagination is more important than knowledge