VBA in MS Access 2007 - 2016 Runtime

Question

VBA in MS Access 2007 - 2016 Runtime

Bernhard Zweifel 41

Hi,

I have developped an application in MS Access 2007 - 2016 using an SQL server for the data tables and Access as Front End.
The application starts by AutoMacro with a form that lets you choose the language used throughout the application and open the switchboard.

Now I compacted and repaired the application and debugged the VBA code with no errors signaled. When I save the application as accde file the runtime version would open but no code is executed.

Whre's the hickup?

Thanks for any advise, boz

Karl Donaubauer 2,951 Reputation points MVP

2021-09-18T11:53:56.647+00:00

Hi,

What about the security settings on the machine with the Runtime version?
Do you use a Trusted Folder or another setting that enables the Runtime to run VBA code?

In case of no, you could try to run Gunter's version fitting AddPath.exe to set the Trusted Folder. Looking at your name I think I can link the German version of the page, but on the left side there are also flags to switch to English: https://www.accessribbon.de/?Sicherheit:Vertrauenswuerdige_Speicherorte

Servus
Karl
Access-Entwickler-Konferenz AEK, Nürnberg, 2.+3. Okt
Access-FAQ (de, it)

3 answers

Your answer

Karl Donaubauer 2,951 Reputation points MVP

2021-09-18T11:53:56.647+00:00

Hi,

What about the security settings on the machine with the Runtime version?
Do you use a Trusted Folder or another setting that enables the Runtime to run VBA code?

In case of no, you could try to run Gunter's version fitting AddPath.exe to set the Trusted Folder. Looking at your name I think I can link the German version of the page, but on the left side there are also flags to switch to English: https://www.accessribbon.de/?Sicherheit:Vertrauenswuerdige_Speicherorte

Servus
Karl
Access-Entwickler-Konferenz AEK, Nürnberg, 2.+3. Okt
Access-FAQ (de, it)

Answer 1

Bernhard Zweifel 41

Thanks for your continued support.

Well, perhaps I was a little sloppy with my wording: What I did is this:

Once I was satisfied with my app (MyApplication.accdb) functioning as front end I validated the VBA Code (Debugging), repaired and compacted the file (database tools) and made a backup (Save As...).
I saved the very same file as MyApplication.accde on my machine I used for the development work to use it in a future runtime environment (I have a laptop with a runtime version installed I will use for demonstration purposes even from remote sites; but that is a next challenge)
I try to open the file and get stuck with the first time code should run.

I used the same procedure successfully when I used MyData.accdb instead of data on an SQL server. But im not sure that the SQL server is the source of the problem. In the development environment, using MyAplication.accdb I can see the data on the server, add records and create reports.

Best regards, boz

Bernhard Zweifel 41 Reputation points

2021-09-19T12:52:52.13+00:00

It's a rainy Sunday and I am in a bad mood anyway! So I searched through the innumerous post related to the above mentioned problem: and I found at the very end of a lengthy exchange of opinions, virtually a footnote, the solution for my promblem. In the accdb file I copy/pasted the form used to access my application switchboard in the desired configuration, deleted the original form, renamed the copy to the original name, saved the file as accde. And it works. Not only this one form, but all forms had their code behind the form re-compiled and responded to click, events etc.

I should be hilarious, but I am primarily furious about the lack of professionality by Microsoft. In my search I found a question whether Microsoft plans to discontinue MS Access in the near future. The answer was a clear NO, because there are to many users depending on it. And Microsoft obviously will keep word. After all, they have a better solution. They will just let it die by rendering it useless!

Answer 2

Hi,

currently I test the runtime version on the machine I used to develop the application.

Sounds dangerous. ;-)

How do you do this? Are both versions on the machine, i.e. a full version of Access (which?) and the Runtime (which?) or did you uninstall the full version before you installed the Runtime?

The registry settings can be tricky depending on the installation variant: Windows Installer or ClickToRun? CTR has its own bubble and you don't always see what you believe to see in terms of paths, registry etc. Therefore in cases of a Runtime install with such problems I prefer to copy Gunter's tool into the folder of the accdb/accde and double click it there. This way I don't get tricked by a bubble, sandbox, deviation or whatever.

Servus
Karl
Access-Entwickler-Konferenz AEK, Nürnberg, 2.+3. Okt
Access-FAQ (de, it)

Answer 3

Hi,

currently I test the runtime version on the machine I used to develop the application.

Trusted locations I set in the Trust Center are the linked drive to the NAS where the linked tables (MySQL) reside, the external drive where the application is stored, and the machine drive for ...\Microsoft Office\root\Office16... (I know I have to expect problems when I want to access my database from an external machine and site, but I will address these issues when "Microsoft" trusts my own installation)
Trusted Documents is activated.
Add-Ins are local (your most valuable AccDevTools and dbPix3.0)
I checked that these security settings are correct in Windows registry entries

Anything else to consider.

Best regards, boz

Share via

VBA in MS Access 2007 - 2016 Runtime

3 answers

Your answer