[AccessD] Upsize?

http://www.amazon.com/gp/product/0672319446/102-8203053-0852936?v=glance&n=283155

...get a copy of "SQL: Access to SQL Server" and follow it religiously 
...its written by Harkins and Reid who are always on this list ...you can't 
go wrong.

William

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