[AccessD] SQL Server 2005 Compact Edition

William Hindman wdhindman at dejpolsystems.com
Sun Mar 25 13:39:08 CDT 2007


...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
> 






More information about the AccessD mailing list