Access Help

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

Using ADO asynchronously in Access to speed up forms2019-03-10T17:54:21-05:00

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

Listen to the Microsoft Access Podcast Episode 12019-03-06T11:40:05-05:00

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

Having issues with Access crashing? Try these solutions first2019-02-28T08:07:03-05:00

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

Access with SQL Server – Import large datasets using a simple SSIS job.2019-02-07T08:30:31-05:00

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

Join me for the first of three Access with SQL Server Acdemy sessions September 11 20182018-09-08T12:30:49-05:00

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

Getting “System Resource Exceeded” messages? Here’s one way to fix it2018-04-22T21:20:43-05:00

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 Microsoft echo system in a 75 mins session.  If y [...]

Meet Michal Bar and me at Microsoft Ignite!2017-09-25T19:32:56-05:00

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 application using combinations of multi-value and single-val [...]

Drag and Drop In MS Access and Conditional Sorting2018-06-27T20:26:39-05:00

Official Access tech blog now online! Also, more improvements to Access!

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

Official Access tech blog now online! Also, more improvements to Access!2017-07-11T01:06:36-05:00

Tuesday April 11th: 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 design? One way of doing this would be to have multiple copies [...]

Tuesday April 11th: Learn how to spawn forms in memory, yes, you heard that right2017-04-10T13:46:05-05:00

The Evolution and Future of 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 group will include an interview with Luke Ch [...]

The Evolution and Future of Access2016-10-05T19:36:13-05:00
FREE CONSULT
close slider