Blog

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+00: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+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

USING SQL VIEWS TO ADD/EDIT DATA IN ACCESS

This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. With relational databases and lookup tables you can eas [...]

USING SQL VIEWS TO ADD/EDIT DATA IN ACCESS2018-09-25T06:14:44+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

Join me for the first of three Access with SQL Server Acdemy sessions September 11 2018

We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday September 11th 2018 I’m going to discuss: When you should or should n [...]

Join me for the first of three Access with SQL Server Acdemy sessions September 11 20182018-09-08T12:30:49+00:00

Using the new SSMA version 7.8, pitfalls to avoid

Microsoft has been updating their SQL Server Management Assistants on a regular basis, and they just updated the SSMA for Access. However you can't see what's new for 7.8 in their official documentation. The latest version of SQL Server Migration Assistant (SSMA) version 7.8 can be downloaded from h [...]

Using the new SSMA version 7.8, pitfalls to avoid2018-07-03T06:33:05+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

Designing a T-SQL trigger

On occasions when building a project involving an Access front-end and a SQL Server backend, we've run into this question. Should we use a trigger for something? Designing a SQL Server trigger for Access application may be a solution but only after careful considerations. Sometime this gets suggeste [...]

Designing a T-SQL trigger2018-06-18T23:47:49+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
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.