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