fbpx

Identifying and Managing Mission-Critical Access Applications During a Development Project

During your Access development project, it is important that you identify mission-critical Access applications. These are the Access databases that are crucial to the success of your project and your business as a whole. If these applications are not functioning properly and you have no idea how to [...]

2022-05-20T05:14:37-05:00May 6th, 2022|

6 Reasons 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 where Microsoft Access comes in. When your comp [...]

2022-04-19T03:46:49-05:00March 24th, 2022|

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

2022-04-19T04:00:03-05:00December 6th, 2021|

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

2021-12-01T12:41:54-06:00December 2nd, 2021|

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

2022-04-19T03:58:50-05:00August 3rd, 2021|

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

2021-06-30T14:54:20-05:00March 2nd, 2021|

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

2021-06-11T05:05:57-05:00July 23rd, 2020|

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

2021-06-11T05:18:54-05:00March 27th, 2020|

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

2021-06-11T05:21:30-05:00February 28th, 2020|
Go to Top