HELP WITH AN EXTREMELY URGENT PROBLEM! :-)
I have an ".asp" page that uses VBScript to try and create and "Access.Application" object. Here is the ENTIRE code:
<%@ Language=VBScript %>
MsgBox "Running test..."
Set appAccess = CreateObject("Access.Application")
appAccess.opencurrentdatabase "C:\Inetpub\wwwroot\BizRulesProject\bizrules.mdb", "administrator", ""
appAccess.Visible = False
appAccess.DoCmd.OpenModule "BizRuleCode", "testme"
MsgBox "Try to run testme in BizRuleCode...."
'run the function
Set appAccess = Nothing
<form NAME="frmINV_INVESTMENT_S" METHOD="POST" ID="Form1">
<BUTTON NAME="Submit" OnClick="test()">Save</BUTTON>
Mu ultimate goal of this script is to execute the following function (named "TestMe") which resides in a Microsoft Access class module named "BizRuleCode":
Option Compare Database
' some comments here
Public Function TestMe() As String
MsgBox "This is a test."
My script errors out on the line of code: Set appAccess = CreateObject("Access.Application") with the error:
ActiveX component can't create object: 'Access.Application'
I've searched practically every Internet resource I can find, but I haven't been able to get this thing running. I have the IIS server installed on my local computer, which is using the XP Professional operating system. My Access version is 2002. I noticed the following statement on "ASP Emporium" that says the following:
You are missing required IIS functionality. You must find and install the proper COM object on your server. For example, if you are getting this error with the class string: "scripting.filesystemobject", you do not have the SCRRUN.DLL installed and registered on your server
I am not sure what "the proper COM object" is to install on my server. Is there a DLL file that I am missing that prevents me from creating objects in VBScript? Is there a permission issue, and how do I tell if there is and how would I resolve it? I have tried to register the msado15.dll and dao360.dll files using "regsvr32" but I am still getting the same error.
I am at my wit's end! Can someone......ANYONE.....help me to get this thing working????? I wish I could give this question 1,000,000 points....