fbpx

Access Help

Alternative solution to DCount and DLookup with SQL Server Backend

One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables.  We recently worked on migrating a pure Access solution to SQL server and encountered delays on the loading of several forms.  This was due to the use of DLookup and DCount in the V [...]

Alternative solution to DCount and DLookup with SQL Server Backend2020-07-23T00:48:05-05:00

Curious about the latest Access features? Join Access insiders!

If you're on Office365 you have a choice in regards to how often you see new features, (some refer to these as rings): Semi-Annual: You get new features every six months, we recommend this channel to all of our clients Semi-Annual Targeted: Think of targeted as a preview of what users will see a mon [...]

Curious about the latest Access features? Join Access insiders!2020-03-27T12:07:53-05:00

New Access features coming your way!

Never discount looking at the What’s New section in Microsoft Office to get a first hand look at goodies coming your way! A fellow MVP pointed out to me how you can see new features by going to backstage, (File menu), clicking on Account and then What’s New. Scroll down until you see new features in [...]

New Access features coming your way!2020-02-28T12:32:51-06:00

Using Access with Azure Multi-Factor Authentication

One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days. Step 1: Extend your domain to Azure AD Before you can enable MFA in Azure you need [...]

Using Access with Azure Multi-Factor Authentication2020-06-29T08:37:42-05:00

Access with Power BI

We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com so that other employees can see the an [...]

Access with Power BI2019-09-08T20:26:01-05:00

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

NETHERLANDS ACCESS DEVELOPER DAY 2019 – 14 SEPTEMBER2019-08-08T09:08:35-05:00

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

Catch my presentation in Iowa next week, 3 cities in 3 days!2019-08-08T11:07:15-05:00

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

Gotchas when using Access Runtime2019-07-19T09:31:11-05:00

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 OASIS-SVN and git for Access source code control2019-08-09T14:41:48-05:00

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
Go to Top