[AccessD] Upsize?

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri Dec 16 16:00:54 CST 2005


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
> 




More information about the AccessD mailing list