fbpx

Evaluating when an expression in a query is evaluated

I've always found Itzik Ben-Gan's excellent chart on the logical SQL processing immensely helpful in reasoning about the querying performance. Even though the chart was made for SQL Server, it still is applicable to any database engine that follow SQL Standard, which also includes Access database en [...]

Evaluating when an expression in a query is evaluated2021-12-01T17:07:57-06:00

Bulk Inserts or Update for tables with Attachment fields

Since Access 2010, Access has supported Attachments data type which on the surface seems like a convenient feature for storing small images or files. However, a quick google search will usually show that they are best avoided. This all boils down to the fact that an Attachments data type is actually [...]

Bulk Inserts or Update for tables with Attachment fields2021-12-01T12:41:54-06:00

7 Ways Microsoft Access Can Help Your Business

7 Ways Microsoft Access Can Help Your Business Almost every business in the world uses Microsoft Excel. For creating simple spreadsheets, it’s probably the best piece of software in the world. But as a company grows and spreadsheets become more complicated, Excel will show its limitations. This is w [...]

7 Ways Microsoft Access Can Help Your Business2021-11-20T03:40:20-06:00

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 VBA2022-01-07T09:06:01-06: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
Go to Top