Access Help

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 your domain to Azure AD Before you can enable MFA in Azure you need [...]

Using Access with Azure Multi-Factor Authentication2019-10-03T07:06:12-05:00

Access with Power BI

We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com so that other employees can see the an [...]

Access with Power BI2019-09-08T20:26:01-05:00

NETHERLANDS ACCESS DEVELOPER DAY 2019 – 14 SEPTEMBER

Access developer day is quickly approaching and you still have time to register and get a discount. It promises to be a great experience with the Access team and some of the brightest Access developers in the world. To register and learn more details please click here: https://www.sys.nl/netherlands [...]

NETHERLANDS ACCESS DEVELOPER DAY 2019 – 14 SEPTEMBER2019-08-08T09:08:35-05:00

Catch my presentation in Iowa next week, 3 cities in 3 days!

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 person: Access can be much faster with SQL Server, allowing many mor [...]

Catch my presentation in Iowa next week, 3 cities in 3 days!2019-08-08T11:07:15-05:00

Gotchas when using 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 runtime. It's not as easy as installing runtime [...]

Gotchas when using Access Runtime2019-07-19T09:31:11-05:00

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

Using OASIS-SVN and git for Access source code control2019-08-09T14:41:48-05:00

Using ADO asynchronously in 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 for it? We will cover how we can improve the responsiveness of t [...]

Using ADO asynchronously in Access to speed up forms2019-03-10T17:54:21-05:00

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 technologies. From highlighting the strengths of Access to [...]

Listen to the Microsoft Access Podcast Episode 12019-03-06T11:40:05-05:00

Having issues with 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 installing updates, (you will see "Update and Reboot" or "Update and Shu [...]

Having issues with Access crashing? Try these solutions first2019-02-28T08:07:03-05:00

Access with SQL Server – Import large datasets using a simple SSIS job.

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 a few minutes to 15). It may even cause your database to hang if th [...]

Access with SQL Server – Import large datasets using a simple SSIS job.2019-02-07T08:30:31-05:00