[AccessD] MS Access 2003/XP - Upsizing Wizard

Yes, Marty, I can directly link tables from MS SQL Server 2000.

I do use MS Windows 2003 Server SP1.

I think now it's firewall *Agnitum Outpost) which blocks Upsizing Wizard 
"talking" to MS SQL.

I will check based on your refs.(Currently have to do other urgent work)

Thank you!

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 1:15 AM
Subject: Re: [AccessD] MS Access 2003/XP - Upsizing Wizard


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