Server.CreateObject("Access.Application")

[David Di Donato]

hi

i have a big problem. i have an asp file with the following source code....

******
Set r_ = Server.CreateObject ("Access.Application.10")

s1 = "DoAnything()"

with r_
.visible = false
.OpenCurrentDatabase "D:\SP5\Data\SPIS_LUPK_Vers.mdb"
sApp = .Eval(s1)
.CloseCurrentDataBase
.Quit acQuitSaveNone

End With

******

my problem is, that the createobject on my iis 15sec. goes....that is not
normally, or ????

what is the problem ? IIS settings ? DComCnfg ?? ASP Problem ??? Wrong
Settings ?

please help me....

thanks
david

[Anthony Jones]

"David Di Donato" <david.didonato@webdev.ch> wrote in message
news:e40PpyqAHHA.4680@TK2MSFTNGP04.phx.gbl...

> hi
>
> i have a big problem. i have an asp file with the following source

code....

>
> ******
> Set r_ = Server.CreateObject ("Access.Application.10")
>
> s1 = "DoAnything()"
>
> with r_
> .visible = false
> .OpenCurrentDatabase "D:\SP5\Data\SPIS_LUPK_Vers.mdb"
> sApp = .Eval(s1)
> .CloseCurrentDataBase
> .Quit acQuitSaveNone
>
> End With
>
> ******
>
> my problem is, that the createobject on my iis 15sec. goes....that is not
> normally, or ????
>
> what is the problem ? IIS settings ? DComCnfg ?? ASP Problem ??? Wrong
> Settings ?
>
> please help me....
>

Access will be expecting to load into a full user environment. However ASP
barely loads any user context at all (it is after in a service process).
It's likely that Access has more work to do that it would normally in an
interactive session.

Can you not do what you need using ADO?

> thanks
> david
>
>