Access is NOT dead, (neither is VBA)
Catch my latest podcast on why Access is not dead! https://accessusergroups.org/microsoft-access-podcast/ [...]
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 details please click here: https://www.sys.nl/netherlands [...]
Catch my presentation in Iowa next week, 3 cities in 3 days!
Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in person: Access can be much faster with SQL Server, allowing many mor [...]
Gotchas when using Access Runtime
We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runtime. It's not as easy as installing runtime [...]
Using OASIS-SVN and git for Access source code control
NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions! As we work with several applications and sometime in a team, source code control is pretty impo [...]
Using ADO asynchronously in Access to speed up forms
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 [...]
Listen to the Microsoft Access Podcast Episode 1
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 [...]
Having issues with Access crashing? Try these solutions first
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 [...]
Access with SQL Server – Import large datasets using a simple SSIS job.
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 [...]
Join me for the first of three Access with SQL Server Acdemy sessions September 11 2018
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 [...]
Getting “System Resource Exceeded” messages? Here’s one way to fix it
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 [...]
