[AccessD] Upsize archaic

Dan Waters df.waters at comcast.net
Wed Jan 5 06:35:20 CST 2011


Would it be possible for you/someone to load and use Access 2003 on the
W2000 PC/server?  Access 2003 and Access 2000 can be installed on the same
PC.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 04, 2011 11: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