What do you think of this article?

[George Hester]

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=251

When I tried it I only had these statements:

<!--METADATA TYPE="TypeLib" NAME="Microsoft Access 11.0 Object Library" UUID="{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}" VERSION="9.0"-->
Dim strDbName, objAccess, objDb, macroCount
strDbName = "C:\Inetpub\database\Images.mdb"
Set objAccess = Server.CreateObject("Access.Application")
'objAccess.Visible = False
'..............
objAccess.Quit acQuitSaveNone
Set objAccess = Nothing

And that left multiple copies of Access running AND objAccess.Visible = False failed.

Winows 2000 SP3 Microsoft Office 2003.

 

[david epsom dot com dot au]

It's not clear what user you had doing this. Access is not
certified for use with a non-interactive user, and there are
some strange interactions:

http://www.4guysfromrolla.com/webtech/042600-1.update.shtml

(david)


http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=251

When I tried it I only had these statements:

<!--METADATA TYPE="TypeLib" NAME="Microsoft Access 11.0 Object Library"
UUID="{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}" VERSION="9.0"-->
Dim strDbName, objAccess, objDb, macroCount
strDbName = "C:\Inetpub\database\Images.mdb"
Set objAccess = Server.CreateObject("Access.Application")
'objAccess.Visible = False
'..............
objAccess.Quit acQuitSaveNone
Set objAccess = Nothing

And that left multiple copies of Access running AND objAccess.Visible =
False failed.

Winows 2000 SP3 Microsoft Office 2003.

 

[George Hester]

Hey thanks (david).

 

[George Hester]

Shoot. It didn't work. I set launch to Interactive User for Microsoft Office Access:


Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/dbmacro.asp, line 9

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

Line 9 is Set objAccess = Server.CreateObject("Access.Application"). The other one at least worked although flawed.

 

[david epsom dot com dot au]

Dunno. We CreateObject on s workstation all the time, and we have
-in the past- had a web service that launched Access, (and a login
that launched Access), but I know nothing about any problems.

(david)
Shoot. It didn't work. I set launch to Interactive User for Microsoft
Office Access:


Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/dbmacro.asp, line 9

The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.

Line 9 is Set objAccess = Server.CreateObject("Access.Application"). The
other one at least worked although flawed.

 

[George Hester]

Yes the article seemed pretty sure of itself but it was obviously not for Microsoft Office 2003. The reason being that the location that was referred to in dcomcng was not what I had. Mine was listed as Microsoft Office Accesss Application not Microsoft Access Application as was in that article. So since I could not satisfy that article verbatum I'm thinking that may be the issue. I even changed the permissions on msaccess.exe also it's home folder to have Interactive as a user Full Control. Didn't help.

 

[George Hester]

Oh my goodness:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;288367

Yikes. There's got to be a better way. I am trying to use an ASP to run a stored query in the database. Trouble is the stored query is just not right. The information that needs to be put in the database is NOT text. It is an OLE Object.

I have a form which does this fine:

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder
'Get the search path
MyPath = MyFolder & "\" & "*." & [SearchExtension]
'Get the first file in the path containing the file extension
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
If InStr(MyFile, "_thm") = 0 Then
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLEEmbedded
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateEmbed
'Check for next OLE file in the folder
MyFile = Dir
'Go to new record on form
DoCmd.RunCommand acCmdRecordsGoToNew
End If
Loop
End Sub

But how to get that to fire from ASP??? The idea from the earlier article was to be able to do this.

 

[George Hester]

I got it working correctly david. Took a little ftom the article I posted in the thread I am replying to and used your link. Thanks for your help.

--
George Hester
__________________________________
Oh my goodness:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;288367

Yikes. There's got to be a better way. I am trying to use an ASP to run a stored query in the database. Trouble is the stored query is just not right. The information that needs to be put in the database is NOT text. It is an OLE Object.

I have a form which does this fine:

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder
'Get the search path
MyPath = MyFolder & "\" & "*." & [SearchExtension]
'Get the first file in the path containing the file extension
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
If InStr(MyFile, "_thm") = 0 Then
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLEEmbedded
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateEmbed
'Check for next OLE file in the folder
MyFile = Dir
'Go to new record on form
DoCmd.RunCommand acCmdRecordsGoToNew
End If
Loop
End Sub

But how to get that to fire from ASP??? The idea from the earlier article was to be able to do this.

 

[david epsom dot com dot au]

-----------
Oh my goodness:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;288367

Yikes. There's got to be a better way. I am trying to use an ASP to run a
stored query in the database. Trouble is the stored query is just not
right. The information that needs to be put in the database is NOT text.
It is an OLE Object.

-------------

Yikes indeed -- but that article includes stuff for DCOM. I didn't know
anybody EVER tried Office with DCOM! We had office running as the command
shell for a Terminal Services login, called from a web page, and as a
snapshot report server, called from a web page but running as a single
instance on a single server (a sperate process clicked 'ok' on any error
messages that might have turned up on the server). We never needed or tried
DCOM. :~)

Glad to see you got your stuff working.

(david)