Uncategorized

Join me Tuesday April 9th for the latest Access news…

Fresh off my MVP Summit last week I’ll be discussing the latest on Microsoft Access. I’ll also be talking about the challenges of taking a product built on Access to the market. Join us! Tuesday April 9th at 630 PM CST (-5 UTC) https://accessusergroups.org/sql-server-with-access/event/375-2019-04-09 [...]

Join me Tuesday April 9th for the latest Access news…2019-04-06T10:47:58-05:00

Listen to Episode 2 of the Microsoft Access Podcast

This episode I’ve got more great examples of why Microsoft Access is great for business, listen and let me know your thoughts. Missed the first episode? You can find it here. [...]

Listen to Episode 2 of the Microsoft Access Podcast2019-04-01T08:22:18-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 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-05: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-05: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-05: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-05: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-05: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-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
FREE CONSULT
close slider