Uncategorized

Join us December 11th for Access with SQL Server Academy Part II

Our first session in September had a great turnout, for our next session on Tuesday December 11th at -6 UTC time, (6:30 PM Chicago CST), comes part 2 where we will cover: – Creating views and optimizing them – Table linking strategies – SSMS tutorial Come join us for what promises to be a great laun [...]

Join us December 11th for Access with SQL Server Academy Part II2018-12-05T09:27:26+00:00

Join me on November 13 with a special guest: Michal Bar from the Access team!

Join me tomorrow November 13th at 6:30 PM live via web conference as I host Michal Bar, Senior Program Manager for MS Access at our monthly AUG meeting, come hear the latest Access news and learn about the revamped Link Table Manager! For more info: https://accessusergroups.org/sql-server-with-acces [...]

Join me on November 13 with a special guest: Michal Bar from the Access team!2018-11-12T11:08:01+00:00

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?

Some of you may already know that Microsoft backtracked on their planned deprecation of OLEDB and provided a new OLEDB driver. However, it can be a headscratcher to figure what you should be using. When we were using SQL Server Native Client, it was pretty easy -- the Native Client had both OLEDB an [...]

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?2018-11-15T09:04:02+00:00

Text or Numeric Field – A simple method to switch data type.

I recently worked on a project where our client is selling a product throughout the USA built on Access with SQL Server, it works by importing data into SQL and then analyzing it with Access reports. Unfortunately each customer may have a primary key format as a long integer and others where it's a [...]

Text or Numeric Field – A simple method to switch data type.2018-06-26T19:49:56+00:00

Join me at SQL Saturday Dallas on May 18th, 2018

I'll be presenting my hugely popular "Wish you could live the glamorous consulting life?" first thing in the morning that day, plus I'll have a table where I'll be answering questions on SQL Server optimization with Access, if you are in the Dallas area please consider attending this great one day e [...]

Join me at SQL Saturday Dallas on May 18th, 20182018-05-12T20:59:08+00:00

Why I’m optimistic about the future of Access

I’m just back from the recent PAUG conference where I had the chance to meet some of the best minds in Microsoft Access, it’s only one of two conferences worldwide, (Access DevCon Vienna is the other one), and it showcased some great content over a three day period. This year’s conference had quite [...]

Why I’m optimistic about the future of Access2018-05-07T23:08:16+00: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+00:00

**BREAKING NEWS** NEW SQL SERVER NATIVE CLIENT 18 released!

As promised, the new SQL Server Native Client 18 is now available to download. Either Ben Clothier or I will be testing Azure authentication and other aspects of ADODB and be providing feedback soon! In the meantime, check out the announcement and other documents below : Announcement: bit.ly/SNC18 O [...]

**BREAKING NEWS** NEW SQL SERVER NATIVE CLIENT 18 released!2018-04-08T16:23:31+00:00

Help us get the IDE modernized in Access, your vote counts!

After my Access with SQL Server meeting were we talked about using User Voice to prompt change to our beloved IDE, I found out that the Access team does not have any sway over the environment, it's handled by the another group in the Office hierarchy. I’ve since endorsed the following ideas on User [...]

Help us get the IDE modernized in Access, your vote counts!2018-04-08T16:15:09+00:00

It’s time we gave the Access IDE some love

Quick: when  was the last time the Access Integrated Development Enviroment  (IDE) got a new feature? I can’t remember. While Access in general has gotten love from the Access team, in particular the new data connectors, its time we add SOME kind of new feature to the IDE, but which one?: Collapse p [...]

It’s time we gave the Access IDE some love2018-02-09T03:48:31+00:00

Inspect the control source of all controls in your project

Happy New Year! Recently I was working on a project where I was implementing form spawning so that my client can see at least two different records using two identical forms, one of the actual forms and the other one a spawned version of itself, (a topic I’ve discussed at my SQL Server with Access m [...]

Inspect the control source of all controls in your project2018-01-24T21:00:24+00:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.