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

Windows Upgarde

Hello,

We are soon going to be having a company wide roll out of the latest version of windows and office package and in anticipation of it coming I wanted to ask what the main differences are between the 2003 Version of Office and the latest distribution? (2010 I think)

Basically we want to make sure we test all of our key systems, macros etc on the 1 test system we have been given before the full roll out hits us.

What sort of changes should we expect that may prevent our VBA scripts etc running?

Thanks

Josh
0
bedsingar
Asked:
bedsingar
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
For the most part, vba is the same.  However, you need to get used to the concept of Trusted Locations for your dbs in the A2010 environment - a folder designated (from within A2010) as Trusted.  Otherwise, VBA will essentially not run.

I would suggest reviewing the material in the links below:

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

Access 2010 Object Model Changes Since Earlier Versions
http://msdn.microsoft.com/en-us/library/ee836189%28office.14%29.aspx

Introduction to Access 2010 security
http://office.microsoft.com/en-us/access-help/introduction-to-access-2010-security-HA010341741.aspx

Access 2010 Development
http://msdn.microsoft.com/en-us/office/ff621506.aspx

Upgrading Solutions to Office 2010 with Application Compatibility Tools and Guidance
http://msdn.microsoft.com/en-us/office/ee722033.aspx

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

mx

0
 
nike_golfCommented:
Personally I would hold off as long as possible before migrating to a newer version of Excel. We recently migrated and the learning curve is steep for the end users and I think it breaks more than it fixes, frankly I think its been a step backwards for Microsoft.

I've not seen the spinning wheel/hourglass since we used Windows 98... it locks up just about as frequently also.

Just my 2 cents worth...

NG,
0
 
bedsingarAuthor Commented:
Thanks I'll sift through those links and hopefulyl we can cover our bases.

Cheers

Josh
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now