fbpx

Blog

Join me next Tuesday September 8th, 2020 for Intro to Access with SQL Server

On Tuesday September 8th, 2020 at 6:30 PM CST we are back from summer vacation to start the new season! We will start with introduction to Access with SQL Server, you can learn more at https://accessusergroups.org/sql-server-with-access/event/375-2020-09-08/ Please join me! [...]

Join me next Tuesday September 8th, 2020 for Intro to Access with SQL Server2020-09-05T09:50:32-05:00

I’ve earned my Access MVP award for another year, here’s how I did it

I often get asked, "how does one become an Access MVP?" 9 Years of MVP Awards When I first started nine years ago, we had over 30 MVPs. Now we have less than 20. Each year, I need to compile my accomplishments and submit them for review, then cross my fingers and hope to be awarded. It’s not like [...]

I’ve earned my Access MVP award for another year, here’s how I did it2020-08-04T12:32:12-05:00

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

Search SQL Server database for stored data.

Have you ever had to decipher a database and identify which column has the data you need? I recently had to work with extracting data from a SQL database to use in Microsoft Access and Power Bi, unfortunately the naming structure of the database was not very intuitive. The only guide I had was a rep [...]

Search SQL Server database for stored data.2020-06-19T01:16:54-05:00

New data type coming to Access is causing problems, here’s how to fix it

[UPDATE: now with Access team link to fixes] Recently the Access team starting working on a new data type called Date & Time Extended, here’s Ebo Quansah, Access program lead: Very soon, we will ship a new data type, known as Date & Time Extended, which enhances syntax compatibility with SQL [...]

New data type coming to Access is causing problems, here’s how to fix it2020-06-10T11:16:14-05:00

Free Field Hospital Database to Fight this Pandemic

Field Hospital Inventory System During these grave times we see field hospitals going up everywhere: Central Park in New York, churches, gyms, parking lots, and more. The COVID Supplies Database is our way of helping humanity in this time of need, its a simple inventory system that’s easy to use, co [...]

Free Field Hospital Database to Fight this Pandemic2020-05-13T20:02:09-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

My thoughts on this year’s 2020 MVP Summit

Last week we had our virtual MVP conference, where I huddled with MVP’s from around the world as we heard and gave feedback to the Access team. Here are some takeaways: I miss sharing with friends I only get to see once a year, but being virtual did have some advantages, one of them being able to re [...]

My thoughts on this year’s 2020 MVP Summit2020-03-25T17:52:28-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

Learn how to performance tune SQL Server

Please join me on February 11th, 2020 when I'll have special guest Jacob Golden from https://www.imyourdba.com/ to discuss how you can improve the performance of your database on SQL Server, can't miss talk! Learn more here: https://accessusergroups.org/sql-server-with-access/event/375-2020-02-11/ [...]

Learn how to performance tune SQL Server2020-02-07T14:47:57-06:00

[UPDATED 2020-01-23] Office 365 Build 1912 breaks ODBC linked tables’ identity

**** Only applies to users on Access with SQL Server table links, otherwise this alert does not apply **** We are getting early reports that the build 1912/2001 released with Office 365 may break the ODBC linked table that contains an identity column, causing different errors. If you receive errors [...]

[UPDATED 2020-01-23] Office 365 Build 1912 breaks ODBC linked tables’ identity2020-01-23T14:22:46-06:00
Go to Top