[AccessD] MS Access 2003/XP - Upsizing Wizard

MartyConnelly martyconnelly at shaw.ca
Thu Mar 16 16:15:16 CST 2006


Can you directly link to tables on SQL Server 2000 from Access?

If you are running WinXP SP2, I wonder if the wizard is using named pipes
or TCP/IP sockets network library or you are using WinXP firewall

How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?kbid=841249
How to use a script to programmatically open ports for SQL Server to use 
on systems that are running Windows XP Service Pack 2
http://support.microsoft.com/kb/839980/

Shamil Salakhetdinov wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list