[AccessD] DAO,VBA,A2K7?

...did they get the single record locking in Dao recordsets fixed in beta2?

...can't believe we get a new Access dedicated Jet engine and 99% of the 
changes go into the gui and hyping SharePoint services ...who the heck 
wanted SharePoint integration as their #1 priority? ...how about spending 
their time integrating ADO and DAO with the best features of each? ...if the 
Windows types no longer control the Access engine, the Access team should 
stop trying to make it into a client/server fe ...that's VB.Net's niche 
...or should be.

...at least it looks like the image bloating issue has been fixed at long 
last (what did it take, ten years?) ...but I'm not moving clients to A2K7 
just for that, a fancier gui, and SharePoint.

...someone needs to kick the MS Access team where it hurts ...if this is all 
the meat in A2K7 I'm going to be putting a lot more time into SSE be's for 
A2K3 fe's for the foreseeable future and keeping an eye out for a viable 
Linux replacement down the road. :(

William

----- Original Message ----- 
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, June 17, 2006 3:31 PM
Subject: Re: [AccessD] DAO,VBA,A2K7?


At the moment William I would say no. DAO has some changes but mostly to do 
with the new SharePoint related types, Attachment and Allow Multiple Values.

I am actually working with both DAO and ADO in 2007 and for all the day to 
day type stuff there would appear to be little changed at the moment.

If you want to send me a sample I can test it out for you in terms of speed 
etc in A2003 and A2007.



Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477


________________________________

From: accessd-bounces at databaseadvisors.com on behalf of William Hindman
Sent: Sat 17/06/2006 20:23
To: Access Developers discussion and problem solving
Subject: [AccessD] DAO,VBA,A2K7?



...those of you working with A2007

...has there been any upgrade to DAO? ...the idea that in A2K3 I have to
connect via ADO, set single record locking, and then change to DAO just to
get that fundamental feature in DAO recordsets drives me nuts ...as does the
idea that ADO performance is so abysmal compared to DAO in local table
lookups and many other areas as to be unacceptable ...has any of this
changed with the new jetdb format in A2K7?

...any notable changes to VBA in A2K7 that would make the upgrade from A2K3
worth the cost and effort?

William



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>





--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>