• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

Which Microsoft suite Office 2010 or Office 2007? I really need to work with Access Database and VBA

Dear Experts

I am very happy working with Microsoft Office 2003, Visual Basic for Applications, Access Database (.mdb), but at this moment I am facing problems since some of my friends have Microsoft Office 2007 or Microsoft Office 2010, and when they send me a .accdb I have to install Office compatibility pack, so I think is time to update my Office suite, my girlfriend asked me what version do I want but I am not sure, I only know that ME and Vista are the worst OS, When Vista and Office 2007 released were very buggy, Office 2010 is still buggy and I really need to work with VBA.

Which suite do experts suggest me Office 2007 or Office 2010?

Thanks in advance for any advice you can provide me
0
rebelscum0000
Asked:
rebelscum0000
  • 4
  • 4
  • 2
  • +4
6 Solutions
 
mbizupCommented:
I'd recommend going with 2010, since it is the most current version.  It has been developed considering and resolving issues that were present in 2007.

In general, when upgrading any software if given a choice I would go with the most current version both for reliability and product support.

From a UI stand point, IMO MS has made an improvement with Office 2010.  
0
 
mbizupCommented:
<I am facing problems since some of my friends have Microsoft Office 2007 or Microsoft Office 2010>

Additionally, if you want to have total compatibility with databases developed under both versions, you would have to go with Office 2010.  

Access 2010 has a few features which can prevent databases from even being opened using Access 2007.
0
 
Stelian StanCommented:
I agree with mbizup, I used both versions and I strongly believe that 2010 is much better than 2007. Here is a good comparison: http://www.makeuseof.com/tag/office-2010-office-2007/
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Helen FeddemaCommented:
2010 is better, but there are some compatibility problems between 2007 and 2010 .accdb databases, which means that you will find it useful to have both 2007 and 2010 installed so that you can fix these problems (described in an Access Archon article; see the link below).  I have Office 2007 installed in a VM for this purpose.  The problems are most likely to occur when .accdb databases are exchanged between people -- sometimes even when both have 2010 installed, but perhaps different upgrades or other differences in their computer environments.

http://www.helenfeddema.com/Files/accarch205.zip
0
 
Dale FyeCommented:
I would concur, but make sure you get the 32bit version of Office 2010, unless you absolutely have to have the x64 version.
0
 
Patrick MatthewsCommented:
And just to be clear, the Compatibility Pack add-in is ONLY for Word, Excel, and PowerPoint.

There is no compatibility support for accdb or accde files in Office 2003 or earlier.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Consider that O2007 is more than 4 years old at this point in time. I can see no logical reason for upgrading to O2007 instead of O2010.  Even many large institutions (like mine) are now skipping O2007 and moving to O2010, wherein the past they would have stayed one major release behind. That's a pretty good indication in itself.  

And as noted, there have been improvements in the UI, especially with the Ribbon, which many people are still struggling with - developers included.

Here are a couple of KB's you might find useful:

Access 2010 Migration Guide:
http://blogs.msdn.com/b/access/archive/2010/09/07/download-the-free-access-2010-migration-guide.aspx

Transitioning Your Existing Access Applications to Access 2007 (And A2010)
http://msdn.microsoft.com/en-us/library/bb203849.aspx

Backward Compatibility between Access 2010 and Access 2007
Features that are not available in Access 2007
http://msdn.microsoft.com/en-us/office/cc907897.aspx

mx

0
 
rebelscum0000Author Commented:
I really need to work with VBA,,
(Visual Basic for Visual Basic for Applications) any expert can give an advice what problems I will have if I upgrading from O2003 TO O2007 or O2010?
0
 
rebelscum0000Author Commented:
And just to be clear, the Compatibility Pack add-in is ONLY for Word, Excel, and PowerPoint.

There is no compatibility support for accdb or accde files in Office 2003 or earlier

You are rigth I am facing problems trying to open Word documents, Excel and PP
0
 
mbizupCommented:
I personally haven't run into any problems specific to VBA that were difficult to overcome during these upgrades.

You WILL have to work with the Trust Center setting up trusted files and/or locations to get your applications to open nicely in Access 2007/2010:
http://office.microsoft.com/en-us/access-help/create-remove-or-change-a-trusted-location-for-your-files-HA010031999.aspx

You are likely to have issues with references.  If you are using VBA code to automate other Office products(eg: Excel, Word or Powerpoint automation code), you may have to update your references.  This is done through the VBA Editor tools--> references from the menubar).  If any references are labeled as MISSING, you can fix them by checking the current version.

You might (but are unlikely) to run into sandbox/macro security issues.  If you are using any of a few select VBA functions ('unsafe expressions') in stored queries or property sheets (not directly in VBA code), they might cause errors when you upgrade.  To resolve this, if you are indeed working just among 'friends', you can easily resolve this issue by changing a registry setting.  If you are working in a corporate environment with tighter security restrictions, you may have to write simple 'wrapper functions' in vba so that these functions are evaluated in VBA, not through property sheets or queries.

This issue is pretty rare, but the functions that cause it and a description of the solutions can be found here:
http://office.microsoft.com/en-us/access-help/functions-and-properties-in-access-2007-blocked-by-sandbox-mode-HA001230190.aspx 
0
 
rebelscum0000Author Commented:
Thank you Experts

I am fan a big fan of Doug Steele,Allen Browne, Stephen Lebans,mbizup and DatabaseMX
0
 
mbizupCommented:
Hey - thanks for the good words...

Glad to help out.
0
 
Helen FeddemaCommented:
Here is a document I prepared on upgrading to Access 2007 (also applies to 2010).
Upgrading-to-Access-2007-or-2010.doc
0
 
rebelscum0000Author Commented:
@mbizup

:)

@Helen_Feddema

Thank you expert Helen_Feddema for this fresh information, excelent document, congrat
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
  • 2
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now