[AccessD] Upsize?

Marty:

Figured it out. I didn't know the name of the SQL Server on my machine so 
that stumped me. But I had downloaded a thing the VS2005 told me to get 
called SQL Server Management Studio Express CTP which is some kind of 
control panel for SQL SE and the opening form had my server name on it, 
which is what the upsizing wizard wanted.  So, using the guidance of my 
Harkins & Reid bible, I got the db upsized.

This .NET thing is going to kill me, I swear.

Rocky

----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, December 16, 2005 2:32 PM
Subject: Re: [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
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>