Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

programming in Acc 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DesCF - 05 May 2007 10:23 GMT
From a purely vba programming point of view are there any substantive  
changes in Acc 2007 compared to Acc XP ?  Or is it all just interface  
changes and a sprinkling of extra properties and methods here and there ?  
What about jet, DAO, & ADO, have they changed much ?

Aim asking from the pov of an Acc 2 - Acc XP programmer who wants to know  
if he neeeds to do some reading up on new stuff or if I can just work with  
Acc 2007 easily if I have to.

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Rick Brandt - 05 May 2007 12:53 GMT
> From a purely vba programming point of view are there any substantive
> changes in Acc 2007 compared to Acc XP ?  Or is it all just interface
[quoted text clipped - 4 lines]
> know if he neeeds to do some reading up on new stuff or if I can just
> work with Acc 2007 easily if I have to.

Access 2007 represents the biggest change between versions EVER.  If you didn't
see the MS logo you would think it was a completely different program.  It is
not just differences in apperance either.  Changes for the developer are
substantial.  So far people either hate it or love it, but either way you will
need some time to get to the same comfort level you have had with Access up to
now.
(IMO)

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

missinglinq - 05 May 2007 13:24 GMT
In there beginning there was Allen Browne! The link below leads you his
discussions of Access 2007, which are the most comprehensive I've seen
anywhere.

http://allenbrowne.com/Access2007.html#Good

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

DesCF - 05 May 2007 15:04 GMT
I knew the DAP was dead but the ADP is dead as well ?

Fromg the link below:
"Access 2007 does not support ADPs as well as previous versions. Microsoft  
recommends using attached tables instead, as explained in the book,  
Microsoft Access Developer's Guide to SQL Server by Andy Baron and Mary  
Chipman."

> In there beginning there was Allen Browne! The link below leads you his
> discussions of Access 2007, which are the most comprehensive I've seen
> anywhere.
> http://allenbrowne.com/Access2007.html#Good

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Rick Brandt - 05 May 2007 15:18 GMT
> I knew the DAP was dead but the ADP is dead as well ?

Mostly in "the handwriting is on the wall" sense.  When a new version as drastic
in the scope of its changes as Access 2007 comes out and an existing feature is
not only not enhanced, but actually pushed into the shadows, I'd say that the
handwriting is in bold-face.

My guess is that ADP will stick around as long as it takes very little effort
for MS to keep it around.  It didn't catch on much when they were cheer-leading
it.  When they stop talking about it altogether it will whither away rather
quickly I should think.

Of course, changes occur in the management of large companies all the time and
at some point a person might be put in a key role at MS that thinks ADPs should
be given another shot.  Anything's possible.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Tony Toews [MVP] - 06 May 2007 01:52 GMT
> From a purely vba programming point of view are there any substantive  
>changes in Acc 2007 compared to Acc XP ?  Or is it all just interface  
>changes and a sprinkling of extra properties and methods here and there ?  
>What about jet, DAO, & ADO, have they changed much ?

Jet and DAO have changed to support the new complex data types.   But as far as the
VBA IDE itself there haven't been any changes.

>Aim asking from the pov of an Acc 2 - Acc XP programmer who wants to know  
>if he neeeds to do some reading up on new stuff or if I can just work with  
>Acc 2007 easily if I have to.

The ribbon and other elements of the GUI will take some getting used to.  But not too
bad at all.  

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.