[AccessD] Upsize archaic

Dan Waters df.waters at comcast.net
Wed Jan 5 07:54:35 CST 2011


I finally remembered - MS has a free tool named SSMA for Access.  This page
has info:
http://www.microsoft.com/sqlserver/2005/en/us/migration-access-learning.aspx

In the FAQ:
Q.  Why should I use SSMA for Access instead of the Office Upsizing Wizard?

A.  SSMA for Access offers a richer set of features, such as network
scanning, conversion assessment reports, and more. SSMA for Access also
fixes many issues currently not handled correctly by the Office Upsizing
Wizard.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, January 05, 2011 7:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Upsize archaic

 > 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.

Maybe.  I know they have Access XP, I am not sure about 2003.  In fact that
is a good point.  I have 
XP on my system there at the client (I have a box in the server room) and
maybe I could open the be 
on my machine, the upsize from there.

I pulled this one table be down to my office and am currently running the
upsize from Access 2003 to 
SQL Server Express directly on my server.  It is chunking along as we speak.

John W. Colby
www.ColbyConsulting.com

On 1/5/2011 7:35 AM, Dan Waters wrote:
> 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.
-- 
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