Our presenter for the next meeting, on March 12th, is Ben Clothier. Ben will talk to us about using ADO asynchronously in Access. Have you had scenarios where you need to load large amount of data but you don’t want to make users wait for it? We will cover how we can improve the responsiveness of t [...]
I've launched a podcast focused exclusively on the business use cases of Access. I felt there was already plenty of technical information online but a real lack of great examples as to why Microsoft Access is an awesome alternative to other technologies. From highlighting the strengths of Access to [...]
If your copy of Access is crashing please try the following strategies to get it stable again: Make sure your PC has the latest updates, including updates for Microsoft Office Verify your PC does not have a reboot pending after installing updates, (you will see "Update and Reboot" or "Update and Shu [...]
Dying with an Access Insert Query If you’ve ever tried to insert a large amount of records into SQL Server using an Access insert query, (15,000 records or more), you’re in for a long wait, were talking coffee break time here, (from a few minutes to 15). It may even cause your database to hang if th [...]
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 September 11th 2018 I’m going to discuss: When you should or should n [...]
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've traced the issue to apps that use a lot of subforms in a tab con [...]
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 Microsoft echo system in a 75 mins session. If y [...]
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 application using combinations of multi-value and single-val [...]
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 regular ones on the office blog. Accessibility Update [...]
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 design? One way of doing this would be to have multiple copies [...]
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 group will include an interview with Luke Ch [...]
