Convert your Microsoft Access application to a Web Application

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications.

Lots of our clients organize their business or even sell solutions around this great tool. But in times of cloud computing, web and mobile devices, the reach and usage of these Windows Desktop-based tools declines. Users require web-based applications, don’t they?

Thinfinity VirtualUI can take your software to the web, and now, your MS Access apps too!

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

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.

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:

Convert your Microsoft Access application to a Web Application

As you can see, there are three commented lines, which make reference to “vui.DevMode” and “vui.DevServer”.

If you uncomment them, you’ll be able to run the database in Development Mode. Let’s do that :

Convert your Microsoft Access application to a Web Application

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.

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

Click on the Run Sub button (F5), and the following message will pop up:

Convert your Microsoft Access application to a Web Application
Click on “Start Web Browser” and you should see both desktop and web applications running at the same time.

Now that we verified that the Development Server is working, let’s take this Access database and take it to the web.

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

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:

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.
“/x StartVirtualUI”: This is the name of the macro that calls the “vui.Start”.

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:

Convert your Microsoft Access application to a Web Application

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

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!

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.

Have any questions? Contact us at support@cybelesoft.com or leave a message on this same post.

Related Posts

Comments (8)

Hi:

I am interested in moving an Access DB to the web. Please give me a call with details.

Hi Steve,
Thanks for your message.
One of our represents will contact you today, in the meantime, you can download
a fully functional 30 days trial of Thinfinity VirtualUI from the link below:

https://www.cybelesoft.com/thinfinity/virtualui/2-5/

Once you install it you just need to follow this tutorial.

Nice Content. My observation tells me that web apps are on the rise, every famous company with a Windows app is looking for development packages to get an HTML5 version of their website.

Hello,

I’ve spent several days testing the sotware with one of our access apps.

Everything runs perfectly except downloading a file.

Can you help?.

Thanks in advance

Hugo Berlinches

Dear Hugo,
Thanks for your comment.
I’ve escalated your issue to our Tech Support team so they can help you to resolve it.
Please expect their email contact later today. If you need a quick resolution you may open a chat session from our website.
Best regards,
Mariana

Good day,

I am trying to test the software. it is giving error message “ActiveX component cannot create object”

assist please

Hello, I am having the same issue with MS Access

Run-time error ‘429’: ActiveX component can’t create object

any help pls? Thank you

Hi Marc and Ugboyemi,

This error is most likely related to our libraries failing to register after you installed Thinfinity VirtualUI .

Open cmd ( admin ) and run the following commands :

“REGSVR32 C:\ProgramFiles\Thinfinity\VirtualUI\bin32\Thinfinity.VirtualUI.dll”

“REGSVR32 C:\ProgramFiles\Thinfinity\VirtualUI\bin64\Thinfinity.VirtualUI.dll”

“REGSVR32 C:\ProgramFiles\Thinfinity\VirtualUI\dev\bin32\Thinfinity.VirtualUI.dll”

“REGSVR32 C:\ProgramFiles\Thinfinity\VirtualUI\dev\bin64\Thinfinity.VirtualUI.dll”

Don’t hesitate to send us your questions to support@cybelesoft.com

Leave a comment