Microsoft Access & SQL Server

Access Database & SQL Server Integration

While an Access Database is a powerful tool, sometimes you need just a bit more power. Fortunately, Microsoft provides an industrial level database called SQL Server that can integrate seamlessly into an Access Database. For more information regarding our SQL Server services, please visit here or for information about Microsoft Azure here. The most common reasons that you will want or need to "upgrade" your Access Database to a SQL Server Database can be found below:

1) The size of your Access Database gets very large and starts running slowly.

2) The number of users in your system grows and, as a result, users are experiencing errors when in the database.

3) You wish to make some of your data available on a web interface.

The Access Experts at WSI have years of experience converting and migrating Access Databases to a SQL Server. We have been involved with hundreds of Access to SQL Server conversions and as such, there are a few different options for converting your database:

1) Convert the Access Database to a SQL Server Database and then re-link the tables in your Access Application to the SQL Server tables using an ODBC connection. This method tends to be the fastest and cheapest conversion route because it requires little to no programming changes to your Access Application.

2) Convert the Access Database to a SQL Server Database; however, instead of using the same Access Application, the Access Application is also upgraded to what is a called an Access ADP project. ADP stands for Access Data Project and it links directly to your SQL Server Database. The forms and reports in your Access Application can easily be converted into an Access ADP, but it is not uncommon for some programming changes to have to be made after the conversion. As such, this method tends to take a bit longer and is a bit more expensive; however, you often seen an even better performance increase by using this method.

Please note that in Access 2013, Microsoft has discontinued the use of the ADP format. This will require you to use linked tables to connect to and to use your SQL Database. We have a template database that contains a number of SQL Functions that make interacting with your SQL Database from inside an Access (ACCDB, MDB) easier to implement. To find out more about this template database and to find out more about the Microsoft Access SQL Functions Database, please click here.

3) Convert the Access Database to a SQL Server Database. Then, for the front end, instead of using an Access Application, you can have WSI develop a custom .Net web or desktop application to work with your SQL Database. For more information on this type of solution, please visit here. This solution takes the most time and cost as the entire front end application is re-written in a new programming environment.

Contact us today to get started on moving from an Access Backend Database to operating with a Microsoft SQL Server Database!

About Us

WSI is a small business and a leading provider of custom access programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom access development experts.