[AccessD] Upsize archaic

jwcolby jwcolby at colbyconsulting.com
Tue Jan 4 23:20:34 CST 2011


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



More information about the AccessD mailing list