380 PASS August 2019 - Optimizing Microsoft Access with SQL Server

This is a past event

4 people went

201 S Clinton St

201 S Clinton St · Iowa City, IA

How to find us

Room 2520 D, second floor roughly half way from the parking garage to the far end, on the west (left) side as you are heading north through the second floor.

Location image of event venue


We will meet for a pizza supper, followed by a presentation by Juan Soto.

SQL Server DBA’s are often asked to take over a Microsoft Access application that has become mission-critical, the conversation usually goes like “You’re a DBA and Access is a database, so take over this system and upgrade it to SQL Server...”, but simply moving the data over may not guarantee better performance and can even make matters worse.

The reality is Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries.

Speaker Bio:

Juan Soto is a frequent speaker at SQLSaturdays.com and prolific author of articles at the official Microsoft Access blog, including being the only Access developer to be profiled on the site. He’s also the founder of AccessUserGroups.org, a worldwide organization of user groups that meet virtually online to discuss Access topics each month in multiple languages and countries. When he’s not presenting he’s managing one of the largest practices of Access consulting in the world at AccessExperts.com