SQL Server with Access

TOPIC: How to upgrade an Access application to use a SQL Server back end

Our meeting this month will be presented by Robert Aaron and Ben Clothier.  In this presentation you will see the bare minimum you need to know to get an Access app running with linked tables on SQL Server, to take advantage of its reliability and security.

You will see all the files you will need, and how to look them up.

We will walk through a simulated installation of SQL Server, the SQL Server Migration Assistant, plus a backup scheduling utility.

We will do an actual upgrade of an application to SQL Server, and you will be told the differences in approaches if you are upgrading a single-database system or if you have a split database.  I will describe several approaches of how you can upgrade a split database.

Robert will also talk about some problems that may arise, and certain things you need to be aware of when doing an upgrade.

We look forward to meeting with you next week, please tell your friends about us.

We now use WEBEX for our monthly meetings, the details are below.

================= MEETING DETAILS ===============================

We meet every second Tuesday of the month at 6:30 pm CDT.

To join our meeting, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, start the meeting from here:


Access Information

Where: WebEx Online

Meeting number: 193 062 171

Audio Connection

+1-415-655-0001 US TOLL

Access code: 193 062 171

International Numbers