[AccessD] Upsize?

Some hints here
FAQ: How to connect to SQL Express from "downlevel clients"

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
and try sql express BOL

Rocky Smolin - Beach Access Software wrote:

>I installed VS2005 which also installs SQL Server Express.  I just tried to 
>use the upsizing wizard but failed to connect.  Do I need to install SQL 
>Server 2005 as well to get that to work?
>
>TIA
>
>Rocky
>
>----- Original Message ----- 
>From: "E-business2start.com - Marcel Vreuls" <oost at e-business2start.com>
>To: "Access Developers discussion and problem solving" 
><accessd at databaseadvisors.com>
>Sent: Friday, December 16, 2005 12:19 PM
>Subject: [AccessD] Upsize?
>
>
>  
>
>>Hi Guys,
>>Just a question. I have distributed Access 97, 2000 and 2003 databases as 
>>backend database with about 600 installations. Now i want to port the 
>>access db to sql server (MSDE). I know the access upsize wizard exists but 
>>this wizard does not seem to to it right.
>>I have a database with about 50 tables which are related with each other 
>>and in many case the relation is made with a query instead of table to 
>>table relation. The upsize wizard does not convert the queries to stored 
>>procedures.
>>Does anyone know a good way to get my access db to sql server with all 
>>tables, relations and queries.
>>Tnx, marcel
>>
>>    
>>
>
>
>--------------------------------------------------------------------------------
>
>
>  
>
>>-- 
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada