[AccessD] Upsize archaic

Jim Lawrence accessd at shaw.ca
Wed Jan 5 10:06:47 CST 2011


You may have to try a two step approach. A2000 to A2003 to SQL Server 2005.

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 04, 2011 9:21 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Upsize archaic

I am trying to upsize a single table from:

Windows 2000 / Access 2000

to:

SQL Server Express 2005

I get the always helpful "overflow" error when trying to do so from inside
of Access.  My guess is 
that Access 2000 does not understand SQL Server 2005 of any flavor, but that
is just a guess.

Has anyone tried this?

I also tried the wizard for SQL Server but it is only valid on Windows 2003
and above.

Any assistance gratefully accepted.

I have modern tools here at my office and I will try zipping and uploading
to my system.

If this works and I get a more manageable experience, I will need to upgrade
about 150 tables.  I do 
not relish moving them to my office for this.
-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list