How to deploy MS Access Client/Server Application?

In a client/server application you need the following:

1. Front-end Application

2. Database (RDBMS)

3. Data Connector between your front-end application and your database, e.g., ODBC.

For this blog, we will use an MS Access front-end application and a MySQL database.

First of all you have to develop the application using MS Access and migrate all your tables to the MySQL Database installed in the server.

The next step is to download the client prerequisite files:

1. MS Access Runtime

2. MySQL ODBC Driver

Install the MS Access Runtime.

Install the MySQL ODBC Driver.

Configure your ODBC Driver base to the link table properties of your MS Access Application.

Make a directory in one of your local drive, e.g., C:\Accounting

In that directory make a batch file, e.g., C:\Accounting\MyProgram.bat.  You must have a UNC share in your server that contains your application/program.

You can now make a short-cut of the newly created batch file in your desktop.

In order for MS Access Runtime to run without security errors you must set the trusted location to your created directory C:\Accounting using Regedit.

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

If done properly your application will run just by clicking the short-cut icon you created in the desktop.

Advertisements
About

Software developer living in the Philippines.

Posted in Microsoft Access
2 comments on “How to deploy MS Access Client/Server Application?
  1. Jerico Canete says:

    nice…I hope this is better approach from previous batch updating technique

    • hgminerva says:

      Yes far better and simpler to implement. You can even combine two version of Microsoft Access, just make sure that you set the default to your application version. To set to the default version just run the Microsoft Access of your application version program once. And by the way you use Microsoft Access run time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Author

Harold Glenn P. Minerva
Software Developer / Tech Enthusiast
Living in the Philippines

View Harold Glenn Minerva's profile on LinkedIn

Instagram

Software Engineer - Seasonal and Range Trading Software. Magenta Trader is a powerful stock market visualization software that increases your probability of trading success.

Software Architect and Founder - Easyfis.com is a multi-tenant cloud-based Software-as-a-Service (SaaS) business app that caters to micro, small and medium trading businesses.

CTO and Co-Founder - We give your company the leverage by providing innovative software solutions products such as Point-of-Sales (POS), Financial Information System (FMIS), Payroll and DTR (HRIS), and many more.

%d bloggers like this: