Uncategorized

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

Using OASIS-SVN and git for Access source code control2019-07-10T22:50:01-05:00

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
FREE CONSULT
close slider