[AccessD] MS Access 2003/XP - Upsizing Wizard

Thank you Marty, for your valuable feedback!

No, I'm running upsizing Wizard on the same PC where MS SQL 2003 is running.

What I did not that a long ago(and MS SQL 200 was installed a long ago) - I 
did change the name of my development/test Windows 2003 Server  PC. This is 
probably the case but as I wrote - other development tools and applications 
work OK with MS SQL Server and I can open connectiions via code etc.

This upsizing wizard is a strange "beast"...

Shamil

----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, March 17, 2006 12:15 AM
Subject: Re: [AccessD] MS Access 2003/XP - Upsizing Wizard


> Some notes and links for Upsizing to SQL 2000 and 2005
>
> There is a problem which occurs when your Access database and the
> instance of SQL
> Server do not exist on the same computer. More so with Express because
> of TCP  and firewalls.
> Avoid if possible.
>
> See blurb further down for fix on SQL 2000, and the Express forums post
> for SQL Express fix.
>
> How to use data transformation services (DTS) to export data from a
> Microsoft Access database to an SQL Server database
> http://support.microsoft.com/default.aspx?scid=kb;en-us;285829
> Note: DTS is replaced in SQL 2005 by SSIS and is also not available for
> Express install.
>
> Access 2003 troubleshoot upsize wizard
>
> http://office.microsoft.com/en-us/assistance/HP030894261033.aspx
> http://office.microsoft.com/en-us/assistance/CH062526781033.aspx
>
> Access 2002 troubleshoot upsize wizard
> http://support.microsoft.com/kb/325019/EN-US/
>
> Access 2003 Database Upgrade to SQL Server 2005
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=128444&SiteID=1
>
>
> Different Machine SQL 2000 upsize problem.
>
> This problem occurs when your Access database and the instance of SQL
> Server do not exist on the same computer.
> WORKAROUND
> To work around this problem, use a File DSN to connect to your instance of
> SQL Server when you upsize your Access database. To do this, follow these
> steps:
> Start Access.
> Open the problem database.
> On the Tools menu, point to Database Utilities, and then click Upsizing
> Wizard.
> In the Upsizing Wizard dialog box, click Use existing database, and then
> click Next.
> In the Select Data Source dialog box, select the appropriate DSN to 
> connect
> to your instance of SQL Server on the File Data Source tab.
> Click OK.
> Enter the appropriate authentication information to connect to your
> instance of SQL Server if the SQL Server Login dialog box appears.
>
>
> Follow the instructions in the Upsizing Wizard.
>
>
> Notice that the Access database is successfully upsized without any 
> errors.
> MORE INFORMATION
> Steps to reproduce the problem
> Start Access.
> Open the Northwind.mdb sample database.
> On the Tools menu, point to Database Utilities, and then click Upsizing
> Wizard.
> In the Upsizing Wizard dialog box, click Use existing database, and then
> click Next.
> In the Select Data Source dialog box, select the appropriate DSN to 
> connect
> to your instance of SQL Server on the Machine Data Source tab.
> Click OK.
> Enter the appropriate authentication information to connect to your
> instance of SQL Server if the SQL Server Login dialog box appears.
>
>
> Notice that you receive the error messages that are mentioned in the
> "Symptoms" section, and you cannot continue the upsizing process.
> REFERENCES
> For more information about the Upsizing Wizard in Access 2003, click
> Microsoft Office Access Help on the Help menu, type About upsizing a
> Microsoft Access database in the Search for box in the Assistance pane, 
> and
> then click Start searching to view the topic.
>
>
> For more information about the Upsizing Wizard in Access 2002, click
> Microsoft Access Help on the Help menu, type About upsizing a Microsoft
> Access database in the Office Assistant or the Answer Wizard, and then
> click Search to view the topic.
>
>
> For additional information about how to use the Upsizing Wizard in Access
> 2002, click the following article number to view the article in the
> Microsoft Knowledge Base:
> MSKB 330468 HOW TO: Use the Microsoft Access 2002 Upsizing Wizard
>
>
> For additional information about issues with the Upsizing Wizard in Access
> 2002, click the following article number to view the article in the
> Microsoft Knowledge Base:
> MSKB 328319 ACC2002: Issues with the Access 2002 Upsizing Wizard
>

<<< tail skipped>>>