artful at rogers.com
artful at rogers.com
Sat Mar 24 09:41:02 CDT 2007
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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com