Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > ColdFusion > COM Objects
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 1676 of 1692
Post > Topic >>

COM Objects

by "PowerLifter1450@[EMAIL PROTECTED] " <PowerLifter1450@[EMAIL PROTECTED] > Jul 8, 2007 at 07:24 PM

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>
 




 4 Posts in Topic:
COM Objects
"PowerLifter1450@[EM  2007-07-08 19:24:02 
Re: COM Objects
Bob Dively <dive@[EMAI  2007-07-09 15:22:02 
Re: COM Objects
"PowerLifter1450@[EM  2007-07-10 00:58:19 
Re: COM Objects
"PowerLifter1450@[EM  2007-07-10 01:22:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Jul 6 10:25:51 CDT 2008.