Office 2013 upgrade

what is the impact of 2013 upgrade in an organisation?

What are things to look at?

For example I discovered that upgrading to access  2013 will not open office 2003 database

What are others things to pay attention to ? Is there a list of known issues after upgrading?
LVL 5
tapiwabAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
If you are upgrading from 2003 or earlier, the toolbar system is completely different, and there would be some retraining.
0
Chris MillardCommented:
Outlook 2013 will not connect to an Exchange 2003 server unless you use POP or IMAP.

New versions of Access have lost some of the earlier controls, and things like DatePickers may need to be replaced for example.

Then there's the standard document format which isn't necessarily backwards compatible without installation of file viewers / converters (i.e. new versions can open older document formats, but not vice versa)
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
New versions of Access have lost some of the earlier controls, and things like DatePickers may need to be replaced for example.
To be clear: Access never had a Date picker. Many people used ActiveX controls, and now find that ActiveX controls are becoming less supported in newer versions. To be fair, MSFT has long advised that you NOT use non-compliant ActiveX controls in the Access environment, but quite a few people didn't listen to that advice and now are paying the cost for it.

I can open several Access 2003 databases with Access 2013, so it can be done. However, in many cases an Access database was improperly developed, and uses items that are not compliant with 2013 (re: the ActiveX controls mentioned earlier). If that's the case, then your 2003 database would not be compliant.

That said - generally it's a good idea to convert your databases to the new format. Doing so makes life easier, since you'll be working in 2013 anyway.

It's a big jump from 2003 to 2013, and quite a lot has changed. There is no more database window, for example. You now have the Navigation Pane. As Philip mentioned, the Ribbon has taken over, and many have troubles with it (especially if you have custom menus and toolbars).

We saw a fair amount of code fixes that had to be done, but almost all of that was the result of poor/lazy coding methods, and as Access matured, it became less tolerant of those practices. For example, often we would see the Filter argument of the OpenReport method used, when the Where argument should have been. Earlier versions of Access handled that correctly, but starting in 2007 Access would complain if you had not properly formed that method. There were others as well - I no longer have the list, but I'm sure it's out there somewhere.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

tapiwabAuthor Commented:
Thank you so much they are a few users on 2003 , the majority of users use Office 2010,

I have been tasked to come up with list of issues that might be affected, thank you for mention access and activex controls,

Is there any issue in Excel or Word ?

are they any other tools to run from the server to get an idea of what users do like Office Telemetry
https://technet.microsoft.com/en-us/library/jj863580.aspx
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I've not run across any problems in Excel or Word - apart from the fact that all of the menus ARE IN CAPS.
 
There are various variants of Excel - see the article PowerMap in Excel for the variants which are needed for something like PowerMap, so you might want to be careful as to what you get.

I would suggest updating one or two computers and seeing If there is a problem.
0
tapiwabAuthor Commented:
thanks once again i think i have an idea of the impact of Office 2013 rollout and what to expect

I got this link as well about known issues for office 2013

https://support.office.com/en-ie/article/Office-2013-known-issues-e9fe113d-fe57-42d9-aaf3-0e112ea4655a?ui=en-US&rs=en-IE&ad=IE
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"If you are upgrading from 2003 or earlier, the toolbar system is completely different, and there would be some retraining."

Specifically, starting in Office 2007, the Ribbon menu system was introduced and remains today.
Up to and including A2010, your legacy custom menus (if any) can still be used without the Ribbon being show. However, in A2013 ... wherein legacy menus are still (barely) supported, they will show up on the 'Add-In's Ribbon ... and cannot replace the Ribbon.

So ... bottom line is you might as well get used to the Ribbon.  And FORTUNATELY, there is an outstanding de-facto standard tool available (nothing is supplied by Microsoft) for creating custom Ribbons:

http://www.ribboncreator2013.de

I use this tool frequently.
0
tapiwabAuthor Commented:
thank you all
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.