Access 2010 should I buy it? Want reasons.

[Avid Fan]

Should I get Office 2010?

I am new to Access 2007 but I really liking it. My wife uses Publisher.

The Google results have not been much help.

 

[Daniel Pineault]

It all comes down to your needs.

Access 2010 has a few new features (see
http://www.databasejournal.com/features/msaccess/article.php/3831411/Whats-new-in-Access-2010.htm
for a listing of some of the new features), but unless you will take
advantage of them there would be no point in upgrading.

Furthermore, I typically avoid jumping in for development on any new MS
product for a good year or so, until the first SP is released, so that the
bugs, and there will be bugs, are ironed out and the product is stable.

So what I am saying is if 2007 suits your needs, then no, do not rush out to
upgrade.

Most of my clients are still running on 2000 and 2003, if that gives you any
idea of the market. Only very small companies migrate rapidly to new
versions, larger organisation take years to implement upgrade. So 2010 won't
be in large corporations for 2-3yrs, maybe more based on past experience.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Arvin Meyer [MVP]]

Should I get Office 2010?

I am new to Access 2007 but I really liking it. My wife uses Publisher.

The Google results have not been much help.

I develop with the version that my clients use, but I'm liking it better
than Access 2007. If you are satisfied with Access 2007, take your time to
read about the new features in Access 2010 before making any decisions. One
of the better places for that is at the Access Team blog:

http://blogs.msdn.com/access/

 

[John... Visio MVP]

Should I get Office 2010?

I am new to Access 2007 but I really liking it. My wife uses Publisher.

The Google results have not been much help.

If you are really new to Office 2007, then you may have purchased it within
the window that qualifies you for a free upgrade to Office 2010 when Office
2010 is released, there is nothing to be lost by getting the upgrade. You do
not have to install it immediately.

John... Visio MVP

 

[AG]

Arvin,

Do you like 2010 better because of some of the new features? Or is it more
developer-friendly? I see a lot of UI bugs and lost features in 2007,
regarding developer operations.

--

AG
Email: npATadhdataDOTcom

 

[Roger Carlson]

My take is that Access 2007 will become the Access 95 of the 21st century,
that is, an interim release that few people will use once 2010 comes out.

I say this, because a number of features that were introduced in 2007 aren't
really useful until 2010. For instance, I consider multiple-value fields
(for tables) and Layout Design (for forms) to be either useless or
down-right dangerous in 2007. However, with the introduction of Web
Databases in 2010, both of these features become necessary. I would never
use either in a client database (that is, one that opens and runs in Access
on the desktop) but I would use these in a database that runs in a web
browser.

Access 2007 introduced a new type of Template, that is more useful than
those in earlier versions, but 2010 introduces another new type of template
called an Application Part, which is meant to incorporate generalized
functions into an existing database application. To my mind, that's more
useful than the normal kind of template.

The result is that many Access 2007 features were really aimed at 2010.
Once 2010 comes out, I expect I'll use that exclusively.

 

[Arvin Meyer [MVP]]

Being a developer, I find it much more developer friendly. There are still
features missing. like User-Level Security, but overall, it is much easier
to use than 2007.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

 

[David W. Fenton]

Being a developer, I find it much more developer friendly. There
are still features missing. like User-Level Security, but overall,
it is much easier to use than 2007.

ULS is not missing from Access 2010, just from the ACCDB file
format.

And I would wager next month's rent that it's never going to be put
into the ACCDB format in any form. It's just not strategic for the
direction MS is taking with Access and its database engine.

 

[Arvin Meyer [MVP]]

ULS is not missing from Access 2010, just from the ACCDB file
format.

And I would wager next month's rent that it's never going to be put
into the ACCDB format in any form. It's just not strategic for the
direction MS is taking with Access and its database engine.

Before users familiar with only Access 2007 are confused, let me point out
that the default file format for both Access 2007 and 2010 is the ACCDB
format. If one hasn't used User-Level Security from earlier versions, they
are unlikely to even think of using the MDB file format. All of the new
features available to both versions are only available in the ACCDB format.

 

[David W. Fenton]

Before users familiar with only Access 2007 are confused, let me
point out that the default file format for both Access 2007 and
2010 is the ACCDB format. If one hasn't used User-Level Security
from earlier versions, they are unlikely to even think of using
the MDB file format. All of the new features available to both
versions are only available in the ACCDB format.

Is that entirely true? I thought it was only the field types that
were available only in ACCDB (none of which matter a rat's ass to an
experienced developer), while the UI features were available in MDB
format?