[AccessD] Old Dog - New Tricks

On 28 Jan 2008 at 10:17, Gustav Brock wrote:

> Hi Stuart
> 
> Why is it "much better"? I haven't worked with it (Access, or rather
> JET is always at hand) so my experience is nil. 
> 
> I can think of the SQL syntax - which I understand is identical to the
> normal SQL Server - and that it can run on PDAs, but doesn't it have
> pretty much the same limitations (size etc.) than Access JET? 


Jet, according to MS is "depreciated technology.  It is no longer part of MDAC.  There don't 
appear be be any intentions to support it on 64bit OS.  Are you sure that it will always be 
available on the target system?

With SSCE, you distribute a few DLLs with your application and you know that the 
environment is exactly the same as on your development machine - no nasty surprises with 
different versions of DLLs on client machines.

Apart from that:

Data Types -- SQL Server datatypes - indexable text  longer than 255 characters, dates to 
millisecond, BigInts...

ACID (Atomicity, Consistency, Isolation, Durability) and Transactions - it's more robust and 
easier to recover from corruption in the event of system crach etc etc.

Transactions

Stronger password and encyrption