Turn your MS Access application to a Web App

Ready to start? First check that you’re running the latest version of Thinfinity VirtualUI. Then download an example for web-enabling Microsoft Access and in the download link below:

https://www.cybelesoft.com/support/files/DemosVUI/VirtualUI_Access.zip

NOTE: On a side note, you may need to do this in order for the demo to work.

After you unzip the file, right click the VirtualUI_Access.accdb file, and click on “Properties”. Check the “Unblock” checkbox, and click “Apply”.

Turn your MS Access application to a Web App - 01

Let’s review the example given on the ZIP file:

There are two things that you should take a look at from this demo:

  1. the “modVirtualUI” module
  2. Adding the VirtualUIStart method to your Main Form.

Turn your MS Access application to a Web App - 02

Convert your Microsoft Access application to a Web Application

Both are needed if you want to successfully compile your application with VirtualUI.

The “modVirtualUI” module contains the call to VirtualUI, and is expressed in the following way:

Turn your MS Access application to a Web App - 03

Now, we need to add  the “StartVirtualUI” method to the Main Form of our Database.

Note: “StartVirtualUI” should be one of the first things Microsoft Access loads when it starts up, so it should be inside the main module of the database.

Turn your MS Access application to a Web App - 04

In this case, the Main Form is Form_Contact List . Right below the “Form_Load()” method, we are adding the call to “StartVirtualUI”

After you commit these changes, save the Access Database.

Open the Thinfinity VirtualUI Server Manager, navigate to the “Application” tab and press “Add”:

Turn your MS Access application to a Web App - 05

Convert your Microsoft Access application to a Web Application

In this new window, we’ll configure the Access Database to be published. Below you’ll see an example of how it’s done:

Turn your MS Access application to a Web App - 06

Let me explain the following fields:

“Name”: The name you want the Web Application to display.

“Program path and file name”: In this case, we are using Office 16, so you’ll have to look for the MSACCESS.exe in the Program Files folder.

“Arguments”: Two things to take into consideration.

“C:\Apps VirtualUI\VirtualUI_Access.accdb”: This is the path of the database you want to load when Access starts.

Under the “Credentials” tab, configure a user that has read and write permission on both the Program Files folder (where Access is ) and where the database is located:

Turn your MS Access application to a Web App - 07

Convert your Microsoft Access application to a Web Application

And under the Permissions tab, for testing purposes, click on “Allow anonymous access”:

Turn your MS Access application to a Web App - 08

Convert your Microsoft Access application to a Web Application

Click “OK”, and then click “Apply”.

Open a new browser window and navigate to: http://127.0.0.1:6580

You will see the Thinfinity VirtualUI landing page, and your application published on it. Congrats!

If you have troubles loading your app in the browser after following the steps above, you might have to make some changes on Windows registry.

To open WIndow registry editor hit “Windows key + R” to open ‘Run’ and type “regedit”.

Here you have to check for the trusted locations in HKEY_CURRENT_USER:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location2

You must replicate the same path in “HKEY_LOCAL_MACHINE”, like this:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location2

(In the examples above we were using Office 16, but you will have to create the one according to your version of Microsoft Office)

Once you are on Location2, you must create a new Key, and in there you will add the path where your access DB is located.

Did you know that you can also use VirtualUI to take WinDev Applications to the web? Take a look at this article to learn how to run Windev apps on any browser.

We want to help our users to put their MS Access databases on the web, so we offer a free 30-day trial and full technical support.

If you have any questions about how to convert an Access 2016 database to web app? Contact us at support@cybelesoft.com or leave a message on this same post.

Cheers!!

Related Posts

Leave a comment

I accept the Privacy Policy * for Click to select the duration you give consent until.