[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 
:-(


On 23 Mar 2007 at 20:13, Gustav Brock wrote:

> Hi Jim
> 
> It is free to download and use.
> But variety of drivers seems very limited - looks like it's mostly aimed at
> dot Net as an embedded database.
> 
> /gustav
> 
> >>> accessd at shaw.ca 23-03-2007 20:03 >>>
> It looks very interesting and no where did I see any indication of time-out
> or cost. Am I missing something?
> 
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Friday, March 23, 2007 11:27 AM To: accessd at databaseadvisors.com 
> Subject: [AccessD] SQL Server 2005 Compact Edition
> 
> Hi all
> 
> Anyone having any experience or opinion on this:
> 
>   http://www.microsoft.com/sql/editions/compact/default.mspx 
> 
> Notice the sync tool for Access.
> 
> /gustav