Join Me For a Microsoft Access with SQL Server Academy Session We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday Septem [...]
How to Fix 'System Resource Exceeded' When Migrating to Windows 10 System Resource Exceeded Error Message Lately we've been seeing a barrage of clients getting "System Resource Exceeded" when migrating to Windows 10, even though the system worked fine in prior versions of Windows. In some cases we' [...]
Meet Michal Bar and Me at Microsoft Ignite! This week Microsoft has invited me to speak at Microsoft Ignite along with Michal Bar from the Microsoft Access team! I'll be in Orlando all week learning about new technologies and on Wednesday afternoon present on how to plug Access into the modern Micro [...]
Drag and Drop In MS Access and Conditional Sorting Drag and Drop In MS Access Doug was on a roll in January of 2004 when he wrote his article on drag and drop in MS Access. He tested it now using Access 2016 and it still works. This article shows you how to add drag-and-drop to your Access applicati [...]
Official Microsoft Access Tech Blog is Now Online! Official Microsoft Access Tech Blog Launches! In addition to the blog on the Office site, the Access team has started a technical blog here. The new Access Tech Blog will be more technical in nature and oriented towards technical users instead of re [...]
Learn How to Spawn Forms in Memory (Yes, You Heard That Right) Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form [...]
The Evolution and Future of Microsoft Access Mark your calendar for next Tuesday October 11th at 6.30pm central time! AccessUserGroups.org was founded by Access MVPs Juan Soto and Ben Clothier in order to foster virtual Access user groups nationwide. This month the meeting of SQL Server with Access [...]
Count All the Objects in Your Database The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search [...]
Use Microsoft SQL Server Native Client 11.0 for the Best Performance [Update] There is a newer version of this post here. In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with DSN-less tables. You could use ODBC 11 for SQL Server but then you wo [...]
7 Ways To Do Sequential Numbering in Microsoft Access Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In oth [...]
Working With Console Tools - Microsoft Access We recently had a project that required us to interact with console tools. People might have different terms for those type of tools so when I speak of console tools, I'm referring to a program or script that opens a command prompt and output stuff to th [...]
