[AccessD] SQL Server 2005 Compact Edition

...thanks Bobby ...certainly worth a look.
William Hindman
----- Original Message ----- 
From: "Bobby Heid" <bheid at sc.rr.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, March 25, 2007 10:30 PM
Subject: Re: [AccessD] SQL Server 2005 Compact Edition


> William,
>
> You can get VS2005 Standard for free if you take 2 or more labcasts.  I 
> sent
> this to the dba-tech list today:
>
> ----------------
> Hey,
>
> If you go to http://www.microsoft.com/business/vb2005upgrade/default.mspx
> and do two or more of the labcasts, you get a free copy (while supplies
> last) of VS 2005 standard,  a book excerpt, discounts on VS 2005 books and 
> a
> poster.
>
> I guess you would not have to do the lab or even watch the video, but you 
> do
> have to submit the evaluation form to get the stuff.  I found the first 2
> labs informative.  The others have not been released on-demand yet.
> -----------------------
>
> The first 2 labcasts deal with using VB.Net with VB6.  But anyway, you get
> to have the full version of C# in VS 2005 Standard.
>
> Bobby
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Sunday, March 25, 2007 2:39 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] SQL Server 2005 Compact Edition
>
> ...not sure Gustav ...I'm looking at C# Express right now ...but Windows 
> CE
> was designed for this, a lot of code exists, and a number of scanners and
> handhelds already use it.
> William Hindman
> ----- Original Message ----- 
> From: "Gustav Brock" <gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Sunday, March 25, 2007 1:16 PM
> Subject: Re: [AccessD] SQL Server 2005 Compact Edition
>
>
>> Hi William
>>
>> Which frontend would you use for that, and how would it connect to the 
>> SQL
>
>> Server 2005 CE?
>>
>> /gustav
>>
>>>>> wdhindman at dejpolsystems.com 25-03-07 19:04 >>>
>> ...as I see it, the major hang-up with SQL Server Express is the size of
>> the
>> installation and that it runs as a service which complicates user
>> installation and maintenance ...SQL Server Compact is "compact" and
>> installs
>> as a couple of DLLs ...its upward data compatibility makes it ideal for
>> some
>> tradeshow floor and scanner apps that I currently do with third party
>> tools
>> ...now I can move them to my own design/code and the data will move
>> between
>> them with a lot less problems.
>>
>> William Hindman
>>
>> ----- Original Message ----- 
>> From: "Gustav Brock" <Gustav at cactus.dk>
>> To: <accessd at databaseadvisors.com>
>> Sent: Sunday, March 25, 2007 4:42 AM
>> Subject: Re: [AccessD] SQL Server 2005 Compact Edition
>>
>>
>>> Hi Arthur et al
>>>
>>> Thanks.
>>> If "wearing Access glasses" it looks like this one feature is the only
>>> important one. On the other hand it seems fair, as it clearly is aimed
>>> for
>>> single user PDA apps.
>>>
>>> /gustav
>>>
>>>>>> artful at rogers.com 24-03-2007 15:41 >>>
>>> I'm with you on that, Stuart. When I first read about its (lack of)
>>> features, I was baffled. There actully is one small reason to use it, 
>>> and
>>> it's not much of one: it's data-compatible with its big sister, so you
>>> can
>>> use DTS or SSIS to easily move data back and forth. Other than that,
>>> maybe
>>> it's so wannabe-geeks can claim they run SQL Server on their little 
>>> toys.
>>>
>>> A.
>>>
>>>
>>>
>>> ----- Original Message ----
>>> From: Stuart McLachlan <stuart at lexacorp.com.pg>
>>> To: Access Developers discussion and problem solving
>>> <accessd at databaseadvisors.com>
>>> Sent: Saturday, March 24, 2007 5:38:31 AM
>>> Subject: Re: [AccessD] SQL Server 2005 Compact Edition
>>>
>>>
>>> Just downloaded the documentation "Compact_Express_Comparison.doc".
>>> Unfortunately, it  doesn't support stored procedures, views, triggers or
>>> role based security.  I can't see any advantages over using an Access BE
>> -- 
>> 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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>