Wednesday, March 08, 2006

Access 2007 - An Overview Of Features

The beta 1 version of Office 12 is rolling along and it looks like it will be called Office 2007. Recently, Microsoft gave the Beta 1 testers permission to discuss the features of what is in the next version of Office. I am sure most of the readers will read many great things from many different people in Microsoft over the coming year or two and some will be true, some will simply be regurgitated media releases and some will be proper analysis of the new product. Anyway for what it is worth, here is a summary of what you are going to find in the next version of Access.

1) The menus are quite different
2) The database container now works like a interactive task bar
3) Access will support MDB files with the new interface and most of the old things that you are used to from Access 2000 onwards. The MDB format will not be developed much further.
4) Access will now have a new file format called ACEDB. If you adopt this format or users convert your database to this format, the following things will not be supported. Access user level security. Replication. Data Access Pages (ADP is still supported)
5) There will be new simpler forms and reports and the macro environment will be improved.

As for things that will appear in the next version, this following statement from Microsoft describes what the focus of the next version is." Our goals for Access 12 are to make new users more successful, to make existing users more productive, and to enable a whole new type of database application built around Windows SharePoint Services."To achieve these goals, the new Database templates are far more prominent in the next version of Access. MS states that there has been a million downloads of the Access 2003 new databases templates and they want to build on this success. It also describes why the menu's were redesigned to make them work the same as the next version of Word and Excel. Finally Sharepoint support means that a lot of changes to Access itself seemed geared around making linked tables work really well into SharePoint services. It seems as if they hope Access will be a prominent tool in supporting SharePoint development. Only time will tell.

As for my feelings on whether I like the next version of Access, I believe that the most important conclusion about the next version of Access is that it is still being treated seriously by Microsoft. Also there is a very good chance that there will be a lot more people using Access in the future because there is no software company in the world that spends more money on user research than Microsoft. Another interesting development sideline is that for ACEDB format databases, the Access team has now taken back development of the jet engine from the Windows development team. This should bode well for future development of Access databases. I cannot say much more as there is still a gag on us discussing our findings of Access 2007 outside the beta website.If you wish to comment on this topic, post your response (good or bad) below.


Anonymous said...

Hi Gary,

Clint Covington, Lead Program Manager Access at Microsoft Corp. said that Data Access Pages are quiet dead in Office 12 / Access 2007. They will be runable but not editable in the new Access 2007 version. His idea: Better use ASP.NET 2.0 / Visual Express instead. Here's the link:

So, what's the truth about DAPs future?

An Access Fan

Garry Robinson said...

DAP are one the way out which isn't suprising as they barely made it in. Access Data Projects are still hanging around but I haven;t had much to do with them in the new incarnation.

franmartinez70045607 said...

While you read this, YOU start to BECOME aware of your surroundings, CERTIAN things that you were not aware of such as the temperature of the room, and sounds may make YOU realize you WANT a real college degree.

Call this number now, (413) 208-3069

Get an unexplained feeling of joy, Make it last longer by getting your COLLEGE DEGREE. Just as sure as the sun is coming up tomorrow, these College Degree's come complete with transcripts, and are VERIFIABLE.

You know THAT Corporate America takes advantage of loopholes in the system. ITS now YOUR turn to take advantage of this specific opportunity, Take a second, Get a BETTER FEELING of joy and a better future BY CALLING this number 24 hours a day.
(413) 208-3069

corporate webhosting said...

corporate webhosting

Can I Help You.. Yes If you want to get on the web. If you want to start learning about creating a web site of your own.. go to to find out more about corporate webhosting ... We can help find a web host for you.

David Billings said...

Does the new version fix any of these problems:

1. Flicker on Tab control if you use a label that is not attached to a control?

2. Security warning user gets when they start up a runtime application?

3. The most recently used version of Access takes over the mdb file name extension and displays an error message of "Unrecognized database format" if the user then opens a database file from a different version of Access.

4. Has MS finally admitted that DAO is the best approach if one is using the Jet engine?