[AccessD] Upsize?

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

...you'll have lots of company :(

William

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, December 16, 2005 6:34 PM
Subject: Re: [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
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>