[AccessD] Upsize archaic

Yes, but neither one (SSMA 2005 or 2008) runs on windows 2000.

John W. Colby
www.ColbyConsulting.com

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