[AccessD] Upsize archaic

jwcolby jwcolby at colbyconsulting.com
Wed Jan 5 07:41:01 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.

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.



More information about the AccessD mailing list