HOME ABOUT MS ACCESS ACCESS DATABASES ON THE CLOUD ONLINE DATABASES CONTACT US
ONLINE ACCESS DATABASE DESIGN

ACCESS DATABASE DESIGN FOR REMOTE ACCESS

MS Access is not intended for storing data online...HOWEVER..

If you have arrived at this page and don't know much about the potential of MS Access then it might make sense to read this page first.

Recap: Access is excellent for:

MS Access is not designed for use over the Internet out of the box - it will eventually (and possibly quickly) result in you breaking the database if you try, however we can set things up such that you can use MS Access from multiple locations with Internet access, getting all of the usual advantages that come with Access without having to be in the office on the same network as your server and without the need for expensive licenses for multiple Remote Desktop users.

How?

MS Access is capable of being split into two parts (indeed this is almost always best practice)

However a front-end Access file is capable of connecting to a variety of other database back ends and many of these are designed for remote connections and perform very well when paired with MS Access. We use this fact and combine MS Access front ends with SQL Server software over an encrypted connection (for data security).

We often use MySQL or MariaDB SQL servers for this purpose though also use MS SQL at times if that is preferred.

The Conversion Process

If you already have an Access database that you want converting for online use then the first stage will be for us to analyse the table structure of your system and check that it is properly "normalised". This is important because it ensures that the database doesn't have large quantities of repeated and redundant data. For a database to work well on the internet we have to reduce the amount of information being passed backwards and forwards as much as possible to maximise speed and usability.

Once the table structure is sorted out we create a SQL server version of the tables and migrate your data to it, connecting your MS Access front end to the back end SQL Server database.

Optimisation

Once the back end data is online there will be a working version of MS Access with data "on the cloud". Now it is time to test the database and see whether any of the business processes that involve larger quantities of data (and therefore slow things down) can be migrated to stored procedures and functions that can be run on the cloud.

Other Possibilities

Now your data is online it can be used to serve data on a website or can accept incoming data from a website designed to collect data. It could be used to create a service used by other web users or to power an app.

20+
Years of Experience
90+
Happy Clients
50+
MS Access Applications developed
15+
Programming Languages
RECENT PROJECTS

RECENT DATABASE CLIENTS

AGCO Finance UK Database

A suite of multi-user MS Access Databases used by a major finance company with connectivity to other in-house systems.

Jigsaw Events Charity Database

A multi-user, SQL Server, cloud-based database with an MS Access front end used by a charity for remote working.

Lawton Tube Fleet Management Database

Multi-user MS Access Databases used by a manufacturing company for delivery fleet management and quality control.

Kingsguard Legal Client Management database

A multi-user, cloud-based SQL Server database with MS Access Database front-end for client relationships management

Kingsguard Legal Client Management database

A multi-user, MS SQL Server database with MS Access Database front-end for membership and case management

TSC Signs order and Production Management Database

Multi-user MS Access Databases for CRM, quotation, order and production management with systems integration for e-commerce orders, deliveries and accounting.

Titan Doors Convert Access Database to Online

Conversion of existing MS Access Database for online use with additional enhancements in usability and performance

Rowelec Contract and Quotation MS Access Database

A multi-user MS Access database for quotation production, client relationship and job management.

LOCATION

9 Blacksmiths Lane, Hockley Heath, Solihull, West Midlands. B94 6QP
Phone: 01564 784825
Mobile: 07815 849467

Give me a call to discuss your needs, or leave me a note: