How to run my vba script from Windows 2003 for Servers?

[ItsMe]

The whole reason I mentioned the RegEdit is because you are using RunTime. The info in post #11 looks to be correct. Here is some additional info. One thing youi might want to do is verify the correct RT was downloaded and installed. I have never installed RT or even Access on a server platform. When I install Access and or RT I make sure to install the 32 bit version. Perhaps this is a snag in your situation.


https://www.accessforums.net/program...tml#post197578

[robs23]

Hi Guys,

I'm attaching the "location" branch under Trusted location in server's registry. Please check it and let me know if it's ok so I could at least have one possibility ruled out.. Well, it reads:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\A ccess\Security\Trusted Locations\Location2]
"Path"="F:\\1356\\Produkcja\\NPD TESTY"
"Description"="Domyślna lokalizacja programu Access: bazy danych kreatorów"
"AllowSubFolders"=dword:00000001

[ItsMe]

The path looks kinda funny to me.
F:\\1356\\Produkcja

So maybe
F:\1356\Produkcja\NPD TESTY\

[robs23]

Good remark, I didn't notice this. I'll change it and try again tomorrow. Will let you know if this resolves it.

[hapm]

The double backslashes are needed for escaping. You can try to add two backslashes

[ItsMe]

The double backslashes are needed for escaping. You can try to add two backslashes

So like this?
F:\\1356\\Produkcja\\NPD TESTY\\

[hapm]

Yep, but I think it'll make no difference. We have a setup, where these settings are deployed using group policies. I'll look up what settings it sets and how the values look like tomorrow, when back at work.

[robs23]

Hi Guys,

It in fact made no difference... Here's the popup I'm getting when hitting my button



I think it translates into this:

The expression OnClick you entered as the event property setting produced the following error: There was a problem while Microsoft Access was communicating with the OLE server or ActiveX Control..

* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.

[robs23]

Sorry for answering my own post, but something else came to my midn. I have a strong feeling (after reading a bunch of related topics though) this may be asociated to the fact, I've been creating and developing my database on machine with "Language for non-unicode programs" setting on Polish language. Now, on the server, default language for non-unicode programs is English and can't be changed (some strange rule for entire company, could be possibly changed after talking to IBM people, but it's not option for me).
Could any of you create a new database (hopefully you have access 2010 and default English language) that would contain only one form with a simple button, that would popped up some msgbox? Ideally the message box would be placed in vba code on button's click event. That would allow me ruling out another possibility..

Btw, how can I set my instance of access into default English language mode? With all of error messages and such in English..

[ItsMe]

Not familiar with default language settings. Might want to look at the Options in the backstage under "File".


Here is an app that loads a form and has an Hello World msgbox in a click event. Access 2010.

[robs23]

Thanks for the file. Surprisingly or not - it's working! Apparently it was all caused by the fact, I created my database on the machine where language defaulted to Polish and tried to launch it on non-polish machine. The craziest of it is that my database was opening correctly, it crashed only when any code was triggering.. As your file worked, I changed my windows "dispaly language" setting to English, composed one of my own and launched it on the server - and it worked perfectly! It would be all way easier if the error read something more implying what the cause might be...
Anyway, big THANK YOU to both of you guys. I'm very happy to know there are still people willing to help

Robert

[ItsMe]

That is good news and I was able to learn a couple things along the way too. As for the error messages in Access, I feel they have come a long way. The used to be a lot more generic. But you still need to take them with a grain of salt and imagine why such a msg was triggered.