[AccessD] Upsize archaic

John,

Have you tried importing the table from SQL Server 2005 express instead of
using the upsizing wizard in Access ?

Paul

On 5 January 2011 12:35, Dan Waters <df.waters at comcast.net> 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.
> --
> John W. Colby
> www.ColbyConsulting.com <http://www.colbyconsulting.com/>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com