Optimizing Microsoft Access with SQL Server IndyPass – 5/21/19

Optimizing Microsoft Access with SQL Server IndyPass - 5/21/19 Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well. Abst [...]

Juan Soto2021-06-11T05:34:40-05:00May 16th, 2019|

Join Me on Tuesday April 9th for the latest Microsoft Access News

Join Me on Tuesday April 9th for the latest Microsoft Access News Fresh off my MVP Summit last week I’ll be discussing the latest on Microsoft Access. I’ll also be talking about the challenges of taking a product built on Access to the market. Join us! Tuesday April 9th at 630 PM CST (-5 UTC) https: [...]

Juan Soto2021-06-11T05:36:39-05:00April 6th, 2019|

Listen to Episode 2 of the Microsoft Access Podcast

Listen to Episode 2 of the Microsoft Access Podcast This episode I’ve got more great examples of why Microsoft Access is great for business, listen and let me know your thoughts. Missed the first episode? You can find it here. [...]

Juan Soto2021-06-11T05:37:44-05:00March 16th, 2019|

Follow Me on Twitter During the Microsoft MVP Summit Next Week

Follow Me on Twitter During the Microsoft MVP Summit Next Week It’s time to visit the mother ship again, a yearly ritual both Ben and I relish as part of our MVP title, where the Microsoft Access team will share the latest, (often under NDA, sorry), I get to meet my peers from around the world and d [...]

Juan Soto2021-06-11T05:38:33-05:00March 14th, 2019|

Using ADO Asynchronously in Microsoft Access to Speed up Forms

Using ADO Asynchronously in Microsoft Access to Speed up Forms Our presenter for the next meeting, on March 12th, is Ben Clothier. Ben will talk to us about using ADO asynchronously in Access. Have you had scenarios where you need to load large amount of data but you don’t want to make users wait f [...]

Juan Soto2021-06-11T05:40:19-05:00March 10th, 2019|

Listen to the Microsoft Access Podcast Episode 1
Listen to the Microsoft Access Podcast Episode 1

Access Help, Blog

Listen to the Microsoft Access Podcast Episode 1

Listen to the Microsoft Access Podcast Episode 1 I've launched a podcast focused exclusively on the business use cases of Access. I felt there was already plenty of technical information online but a real lack of great examples as to why Microsoft Access is an awesome alternative to other technologi [...]

Juan Soto2022-01-07T09:00:56-06:00March 6th, 2019|

Having Issues with MS Access Crashing? Try These Solutions First

Having Issues with MS Access Crashing? Try These Solutions First If your copy of Access is crashing please try the following strategies to get it stable again: Make sure your PC has the latest updates, including updates for Microsoft Office Verify your PC does not have a reboot pending after install [...]

Juan Soto2021-06-11T05:42:21-05:00February 28th, 2019|

Access with Microsoft SQL Server – Import Large Datasets Using SSIS

Access with Microsoft SQL Server – Import Large Datasets Using SSIS Dying with an Access Insert Query If you’ve ever tried to insert a large amount of records into SQL Server using an Access insert query, (15,000 records or more), you’re in for a long wait, were talking coffee break time here, (from [...]

Susan Pyne2021-06-11T05:43:49-05:00February 7th, 2019|

Join us for the Microsoft Access with SQL Server Academy Part II

Join us for the Microsoft Access with SQL Server Academy Part II Our first session in September had a great turnout, for our next session on Tuesday December 11th at -6 UTC time, (6:30 PM Chicago CST), comes part 2 where we will cover: – Creating views and optimizing them – Table linking strategies [...]

Juan Soto2025-05-24T19:05:56-05:00December 5th, 2018|

Join Me with Special Guest Michal Bar from the MS Access Team!

Join Me with Special Guest Michal Bar from the MS Access Team! Join me tomorrow November 13th at 6:30 PM live via web conference as I host Michal Bar, Senior Program Manager for MS Access at our monthly AUG meeting, come hear the latest Access news and learn about the revamped Link Table Manager! Fo [...]

Juan Soto2021-06-11T05:45:32-05:00November 12th, 2018|

Using SQL Views to Add/Edit Data in Microsoft Access

Using SQL Views to Add/Edit Data in Microsoft Access This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. Wi [...]

Susan Pyne2022-01-07T08:59:56-06:00September 25th, 2018|

Blog