[AccessD] .net

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Tue Feb 4 11:19:00 CST 2003


I would say that coming are many changes to the way we use SQL Server and MSDE 
and Access. I would guess that some of these changes will not be for the 
better.

Access has a massive installed user and developer base and will always be 
about. 

.NET is Microsoft strategic direction in programming applications and the web. 
Up to each programmer if they stick with Access or move to .NET. There will 
always be Acess work there.

Theres work with SQL Server and MSDE thats in the nature of the beast just 
like Oracle. Big relational systems running the enterprise need work. Nice and 
easy. NO one ever said SQL Server was maintenace free but there are many 
developments taking place to relieve the DBA of day to day work fore example 
built in dynamic performance monitoring. IBM and DB2 have some interesting 
areas.

JET got the job done until you scale up and have 20000 users and terrabytes of 
data. 

In my view MSDE was a marketing ploy. Nothing else.

For whats its worth I have expressed similar concerns directly to MS on many 
of the issues raised especially the future direction of SQL Server, ADPs and 
Access. But you need to be a rela big name int he developer world to get heard 
properly.


Martin


Quoting Francisco H Tapia <my.lists at verizon.net>:

> AFAIK, MS never claimed for Sql Server or MSDE to be 'maintenance-free',
> and
> they 'are' easier to use when compared to Oracle or DB2, and for that
> matter
> even mySQL.  While all engines, are simple and straightforward, (after
> you
> read the documentation) they all have their own level of complexity. 
> JET,
> for example crumbles under the load of Memo fields.  There is also 0
> recoverability from a damaged .mdb file, if you MDB gets corrupt and the
> MS
> tools can't fix it, you are generally dead in the water.  Sql Server
> and
> other big brand engines provide for up to the point of failure
> recoverability.  In order to use SqlServer or MSDE it does involve a
> great
> deal of learning the product, but I think it's just the same as when we
> all
> started down the road with JET.
> 
> -Francisco
> http://rcm.netfirms.com
> ----- Original Message -----
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: <accessd at databaseadvisors.com>
> Sent: Tuesday, February 04, 2003 8:27 AM
> Subject: RE: [AccessD] .net
> 
> 
> : Unless common sense rears its ugly head somewhere along the way. 
> SQL
> : Server and the desktop engine are not the maintenance free,
> easy-to-use
> : creatures that MS claims.  At least Jet got the job done without
> needing
> : a dba on tap.
> :
> : Charlotte Foust
> :
> : -----Original Message-----
> : From: Martin Reid [mailto:mwp.reid at Queens-Belfast.AC.UK]
> : Sent: Tuesday, February 04, 2003 7:33 AM
> : To: accessd at databaseadvisors.com
> : Subject: Re: [AccessD] .net
> :
> :
> : I think the true future of Access will not be really known
> : until Access 12 is available. I do know JET and DAO are
> : dead today. No further development of either AFAIK. Could
> : all change but we have to wait and see.
> :
> : Lot of confusion it would appear
> :
> : Martin
> :
> : Martin WP Reid
> : Information Services
> : Queens University Belfast
> :
> : Tel: (02890) 273750
> :
> :
> : ----------------------
> :
> :
> : _______________________________________________
> : 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
> 



More information about the AccessD mailing list