[AccessD] MS Access 2003/XP - Upsizing Wizard

If you are still stuck, here is a commercial product UPSizingPro from 
Sydney Software in Australia
The downloadable trial version defaults to a freebie version that only 
allow 10 tables after 60 uses.
http://www.ssw.com.au/SSW/UpsizingPRO/
It creates an output SQL script like the following which can be useful 
in other situations

CREATE DATABASE [add database name here]   
GO

CREATE TABLE [Test2]
(
    [TestField2] varchar  (50) NOT NULL ,
    [TestField3] varchar  (6) NOT NULL ,
    [Notes] text NULL
) ON [PRIMARY]
GO




Shamil Salakhetdinov wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada