fbpx

Avoid This Common Error When Executing Stored Procedure in MS Access

Avoid This Common Error When Executing Stored Procedure in MS Access   We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following [...]

Avoid This Common Error When Executing Stored Procedure in MS Access2021-06-30T14:54:20-05:00

Alternative Solution to DCount and DLookup with MS SQL Server Backend

Alternative Solution to DCount and DLookup with MS SQL Server Backend   One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables.  We recently worked on migrating a pure Access solution to SQL server and encountered delays on the load [...]

Alternative Solution to DCount and DLookup with MS SQL Server Backend2021-06-11T05:05:57-05:00

Curious About the Latest Microsoft Access Features?

Curious About the Latest Microsoft Access Features?   If you're on Office365 you have a choice in regards to how often you see new features, (some refer to these as rings): Semi-Annual: You get new features every six months, we recommend this channel to all of our clients Semi-Annual Targeted: [...]

Curious About the Latest Microsoft Access Features?2021-06-11T05:18:54-05:00

New Microsoft Access Features Coming Your Way!

New Microsoft Access Features Coming Your Way!   Never discount looking at the What’s New section in Microsoft Office to get a first hand look at goodies coming your way! A fellow MVP pointed out to me how you can see new features by going to backstage, (File menu), clicking on Account and then [...]

New Microsoft Access Features Coming Your Way!2021-06-11T05:21:30-05:00

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

7 Step Guide to Using Access with Azure Multi-Factor Authentication2021-06-11T05:29:42-05:00

Using Microsoft Access with Power BI

Using Microsoft 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 s [...]

Using Microsoft Access with Power BI2021-06-11T05:30:39-05:00

Microsoft Access is NOT Dead and Neither is VBA

Microsoft Access is NOT Dead and Neither is VBA Catch my latest podcast on why Access is not dead! Episode 1: Introduction to the podcast Episode 2: More great examples of why Microsoft Access rocks for business Episode 3: Why Microsoft Access is NOT going away Episode 4: Best practices for Microsof [...]

Microsoft Access is NOT Dead and Neither is VBA2021-06-11T05:31:34-05:00

Netherlands Access Developer Day 2019 – 14 September

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

Netherlands Access Developer Day 2019 – 14 September2021-06-11T05:32:18-05:00

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

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation2021-06-11T05:33:14-05:00

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

Gotchas When Using Microsoft Access Runtime2021-06-11T05:33:54-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 control2021-06-10T10:53:03-05:00
Go to Top