VMware Horizon Community
Sergei13
Enthusiast
Enthusiast

Launching local Word from Access DB run from Access in Thinapp mode

HI,

I have an Access DB (.mde) running from a Access 2003 Thinapped.

At some stage, this DB application kicks off a Winword document.

In a all packages installed localy mode, everything is fine.

When I only have Office standard installe with Access Thinapped, I can only get an error message ????

Any idea ?

Many thanks.

Reply
0 Kudos
4 Replies
Cievo
Commander
Commander

Next time you want to help with error, please, describe error. We don't know what error you get, so we don't what problems you have.

Thank you,

***Good question is half of the answer...***
Reply
0 Kudos
Sergei13
Enthusiast
Enthusiast

Nope, Thank you Cievo,

It was rather late yesterday and I was drawning into my tests ...

So, the error message, translated to English is something like :

The expression under Click action set as event parameteris the orgine of the error. Authorization refused.

What this button does is

     Set vl_WordDoc_Obj = CreateObject("Word.Application")
     NomDoc = "basedoc.dot"
     vl_WordDoc_Obj.Documents.Add Template:="\\ServerName\Directory\" + NomDoc, NewTemplate:=False
     vl_WordDoc_Obj.Selection.GoTo , Name:="idfield"

     vl_WordDoc_Obj.Selection.TypeText Text:=rs.Fields("clientid").Value

     ...

Basically, based on a request, I open a word document based on a template and fill it up with data.

Hope this is more comprehensive.

Reply
0 Kudos
Sergei13
Enthusiast
Enthusiast

Well, I have re packaged the all Office 2003 suite and tried it again .. successfully.

I guess it required some stuff that is only installed with the installation of the other applications from the suite.

And just to confirm, it runs the Word installed localy even if Word was part of the package.

Cheers

Reply
0 Kudos
Cievo
Commander
Commander

Self-solving solution 🙂

Have a nice day,

***Good question is half of the answer...***
Reply
0 Kudos