Hi all, I have the followinig code in a .cfm page to run a query in an
MS-Access DB. However, when I load the page, I see the MSACCESS.EXE
process open, but the loading of the page hangs there and nothing
happens. I see the lock file for the DB created, but that's it. Any
ideas?
<!--- Try to connect to the Access application object --->
<CFTRY>
<!--- If it exists, connect to it --->
<CFOBJECT
ACTION="CONNECT"
CLASS="Access.Application"
NAME="objAccess"
TYPE="COM">
<CFCATCH>
<!--- The object doesn't exist, so create it --->
<CFOBJECT
ACTION="CREATE"
CLASS="Access.Application"
NAME="objAccess"
TYPE="COM">
</CFCATCH>
</CFTRY>
<CFSET objAccess.OpenCurrentDatabase("C:\CFusionMX7\wwwroot\ron
\customer.mdb")>
<!---<CFSET objAccess.DoCmd.RunMacro("XDeleteWeb")>--->
<CFSET objAccess.CloseCurrentDatabase>
<CFSET objAccess.Quit(Access.AcQuitOption.acQuitSaveNone)>
<CFSET objAccess = Nothing>


|