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 [...]
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 [...]
The Access team has released a new test version that includes a dataverse connector, from Michael Aldridge, program manager from for Access: Hello Microsoft Access community ! I am excited to let you all know we shipped the public beta of the Access Connector for Dataverse and Power Platform at Igni [...]
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 [...]
[Update] Post has been updated to correct the maximum size of the database to 10 Gigs When should you use SQL Server with Access? (Hint: Almost always) Look, I’ve heard the phrase “When all you have is a hammer everything looks like a nail” and given that our specialty is Access with SQL Server at I [...]
Bug Causes Microsoft Office 365 Build 2105 Breaks Access Applications UPDATE: The bug may be due to the vbWatchDog crashing on 64-bit builds. We initially reported that this was an issue affecting the 2105 build in general. However, further findings and additional reporting has indicated that [...]
Check Out the Latest News on Microsoft Access, Including Access 2022! Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit T [...]
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 [...]
Easily Convert Your Microsoft Access Queries With This New Tool! AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a rea [...]
Where to Download the Runtime Kit for Microsoft Access 2016 If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are mul [...]
Writing Readable Code for VBA - Try* pattern Lately, I've been finding myself using the Try pattern more and more. I really like this pattern because it makes for much more readable code. This is especially important when programming in a mature programming language like VBA where the error h [...]
