Uncategorized

7 Step Guide to Using Access with Azure Multi-Factor Authentication

7 Step Guide to Using Access with Azure Multi-Factor Authentication One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days. Step 1: Extend [...]

2021-06-11T05:29:42-05:00October 3rd, 2019|

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation

Catch my 'Optimizing Microsoft Access with SQL Server' Presentation Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in [...]

2021-06-11T05:33:14-05:00August 6th, 2019|

Gotchas When Using Microsoft Access Runtime

Gotchas When Using Microsoft Access Runtime We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runt [...]

2021-06-11T05:33:54-05:00July 19th, 2019|

Using OASIS-SVN and git for Access source code control

NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions!   As we work with several applications and sometime in a team, source code control is pretty impo [...]

2022-01-07T09:04:42-06:00July 2nd, 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: [...]

2021-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. [...]

2021-06-11T05:37:44-05:00March 16th, 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 [...]

2021-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 [...]

2021-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 [...]

2021-06-11T05:44:47-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 [...]

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

Detangling the New Microsoft SQL Server ODBC and OLEDB Drivers

Detangling the New Microsoft SQL Server ODBC and OLEDB Drivers Some of you may already know that Microsoft backtracked on their planned deprecation of OLEDB and provided a new OLEDB driver. However, it can be a head-scratcher to figure what you should be using. When we were using SQL Server Native C [...]

2021-06-11T05:47:43-05:00September 11th, 2018|
Go to Top