For the past two weeks, one of my clients has been having trouble upsizing his Microsoft Access 2003 database (MDB) into a SQL Server database at his shared hosting provider. The problem was that the tables would be created fine, but then the upsizing would fail when Access attempted to insert the data.

I attempted the same procedure on my machine, to the same database, using Access 2007 and did not have any trouble. The table and data were upsized properly.

So my initial thought was something wrong with my client’s specific installation of Access 2003. However, he installed Access 2003 on More >