Migrating Larger Tables to SharePoint

This is the third, and possibly the last, in a series of blog posts on my experiences migrating data from a working Access/SQL Server database to SharePoint, where it now serves me daily. It's a "hybrid" database, in the sense that the Front End is the original Access accdb, complete with all of the original VBA intact, while the Back End lives on SharePoint.

Patching Up Relationships On SharePoint Migrations

In my last previous blog post, I described one of the problems with exporting existing tables from Access or SQL Server to SharePoint. SharePoint bumps the existing Primary Key field out of its way and replaces it with a new one which SharePoint generates in its place. Here’s how that looks.

Disappearing Primary Keys Notwithstanding, You Can Migrate to SharePoint

Recently, a poster at Utter Access asked for help moving Access tables from an existing database to SharePoint tables (or more accurately, to SharePoint lists). His goal was to link to those tables in a Hybrid Access database. One of the issues raised was the supposed limit on the number of records you can export. Fortunately, a couple of really knowledgeable people, Albert Kallal and Bonnie Hicks, stepped in and helped address the poster’s questions.

"Microsoft Access in a SharePoint World" Is Available

I'm delighted to announce publication of a new, first-of-its-kind, book on Access 2010 and SharePoint 2010. It's been a long time in the writing, but we finally wrapped it up.

How Much Does an Access Database Cost?

Lately I've been pondering the implications of some of the questions we get at Utter Access. It used to be that I worried more about giving the questioner an answer appropriate to their situation, but lately, I’ve also been asking myself, "How much will that technique cost?"