"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)

Microsoft Access Conversion/Migration

Upgrade Your Access Database

Iowa Headquarters
(MIDWEST)
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800
Skype™

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
Iowa/Illinois - Quad Cities/Muscatine
Tel: (563) 316-2378
North Carolina - Asheville
Tel: (828) 278-2323
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
 
Click Here To Chat With Us Now Live!!
Disclaimer
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.

Microsoft Access Conversion/Migration

Upgrade Your Access Database

I want to convert to:
We hope you find the following free information helpful. WSI can perform any of the following conversion services described below for you, for a fee, if you do not want to do them yourself. Please contact WSI today to start the process of getting a cost estimate.

A newer version of Access

Have you been running an Access database for many years using an older version of Microsoft Access like Access 95, 2002, 2003 etc.? Do you need to get your database working properly in the newest version of Access? If you answered “yes” to any of these questions, WSI’s service is for you! We’ve moved hundreds of Access databases, simple to complex, from older versions of Access to the new ones. We know what it takes. We have the experience to do it quickly. Contact WSI today to find out how the process works and what it costs to get started!

A split Microsoft Access database

An Access database can start out as a single file that contains both the Access Front End (FE) and Access Back End (BE). The FE includes the screen forms, reports and queries. The BE includes the tables that hold your data and their relationships. To enable your single file Access database to better support multiple users (up to 10 in most cases) it should be “split” into a separate Front End and Back End. Another benefit of splitting the database is that it allows for most changes to be made to the FE while users are working in the database. Front End changes that affect the Back End such as adding new fields need to be done when the database is not in use. Front end changes such as creating new reports from existing data fields can be done while the database is in use.

An Access Database to Runtime

Runtime is an amazing, powerful and money saving feature that many people do not know about. People assume that you have to have a purchased license of Microsoft Access installed on every computer you want to use your database on. This is not necessary. By converting your Access database to Microsoft Access Runtime and installing Microsoft’s free runtime program on each PC you want to use the database on, you can run your database on that PC without the purchase of a Microsoft Access license. Another feature of Access Runtime is that it prevents users from modifying the way the database works. As long as you have installed one purchased license of Access and a pre-Runtime conversion copy of your database, you or anyone with sufficient knowledge of Microsoft Access can modify the way the database functions.

An Access Database from 32bit Access to 64bit Access

First, WSI does not recommend nor does Microsoft require you to run the 64bit version of Access. You can run the 32bit version of Access on the 64bit version of Windows. This is the configuration that WSI recommends. The 32bit version is recommended because many Access databases are 32bit since Access has been in widespread use for over 20 years. Depending on the amount and quality of programming in your Access database there may be anywhere from zero programming changes to hundreds in order to get it to work properly in the 64bit version of Access.

An Access database with a Microsoft SQL Server backend

Access is a super database platform but people disparage it for not being able to handle large amounts of data. It is true that Access is limited to storing 2GB of data. BUT…WSI can show you how to squeeze the most out of that 2GB. WSI can also convert your Access database back end (BE) (the part where the tables that store all your data reside…) to Microsoft SQL server which is an enterprise class relational database. For many Access users who are at or approaching the 2GB Access data size limit, there is no licensing cost for Microsoft SQL Server Express Edition. This version stores up to 10GB of data and there is no licensing fee! WSI has upsized dozens of Access databases to Microsoft SQL server. We build many new Access databases using Microsoft SQL server from the very beginning.

A Web Application

Wouldn’t it be great if people could view or enter data into your Access database from a web browser? Over the years, Microsoft has touted several technologies that they claimed would do this. But all have had serious limitations or been discontinued. Don’t despair. It will take some time and money but WSI can make it happen for you! First, we will need to convert your Access database to have a Microsoft SQL Server back end (BE) if it does not already have one. Then we need to work with your staff or contracted IT person to make the database accessible over the Internet if you are hosting on your premises. If you prefer, we can put the Microsoft SQL Server BE on a server at a hosting company of your choice, on our hosting service or on Microsoft’s Azure SQL cloud platform. Then we will need to create versions of your Access screen forms that work in a web browser. We do this using Microsoft .NET technology programmed using Microsoft Visual Studio. It is not as simple as Access but it the best way to give users the ability to work with your Access database data from a web browser.

A Mobile Web Application

The process is the same as a Web Application. WSI builds Web Applications using a “responsive” design. Responsive designs make their best effort to scale from a large HD or 4k desktop monitor to a smart phone sized screen. However, applications that have lots of fields per screen form may need to be redesigned to display properly on a smaller screen. You may also want the web application to do things that typically aren’t done on a desktop web application. For example, on-screen signature capture, digital photo capture, GPS location coordinate capture and more. In this scenario you need a mobile web application.

A Microsoft PowerApps Application

PowerApps is an amazing tool from Microsoft. WSI sees the best fit for PowerApps with our Access clients in its ability to provide Front Ends that run like a native smart phone application on your iOS or Android phones and tablets. Access does not run natively on iOS, Android or Mac OS. (There are work arounds.) PowerApps also run in a web browser, so they work on Mac OS too! Native iOS applications can be challenging to distribute if you want to limit availability to your workforce by not publishing your business application to the public Apple app store where all the games and other iOS applications are made available. WSI can help you work through the process, for a fee, but Apple does not approve all applications. In order to use PowerApps you need an Office 365 subscription that includes PowerApps. At this time all users of the application must be part of your Office 365 subscription. If you want a person who is a customer or who works with a business partner to utilize your PowerApp, they cannot, even if they or their business has their own Office 365 subscription with PowerApps. A great use for PowerApps is to create a form that your employee needs to use in the field to do their job. Such as a work order form.

A native iOS or Android Application

Since Access, web applications, mobile web applications and even PowerApps have their respective limitations, you may need to convert parts or all of your Access database to a native iOS or Android application. This gives you the most power and flexibility to fully utilize features on the smart phone such as finger print or facial ID, control over the user interface and other phone hardware specific capabilities. Native iOS and Android applications can be costly to develop. WSI recommends trying to get by or start off with a mobile web or PowerApps application first. WSI can consult with you, on your specific situation, to help you make the right decision.

Click Here to get a free quote for your Microsoft Access Database needs.
Click Here to learn more about the WSI quoting process.

*While WSI does provide free quotes, it is necessary to have a detailed specification that shows the changes to your existing database or what is required for your new database.

Microsoft Access Upgrade Common Questions

We moved to a newer verson of Access and there is a new format - ACCDB - do we need to upgrade/convert our application?

The accdb format is the new format for databases created in Microsoft Access that was begun in Access 2007. You old MDB format databases will continue to run under Access 2007 and later. However, any new features that are found in Access 2007 and later can't be put into a database that is still in the mdb format. Because of this, we typcically recommend that you upgrade you older mdb databases to the newer accdb format. Contact us today for a free estimate to begin to see how WSI can help you upgrade your database.

Do you upgrade a database onsite?

WSI prides itself in being flexible and able to fit into your organization in many different ways. One of these is playing whatever role, whether large or small, you wish for us to play. We provide you either a single individual or a team of consultants based on your needs. Contact us today for a free estimate to begin to see how WSI can help you upgrade your database.

We're located a long distance from your office - how could this work?

In situations where distance is an issue, we provide two options. One, our consultants will travel to your location and stay for a defined period of time. This is usually only cost effective for longer projects, but it is an option for shorter term projects as well. The second option is for us to perform the project remotely - we've done hundreds of projects remotely without ever attending the clients location with great success. Contact us today for a free estimate to begin to see how WSI can help you.