Access Office 365

Jaye7

Registered User.
Local time
Tomorrow, 04:39
Joined
Aug 19, 2014
Messages
205
My boss wants us to upgrade Access on our terminal server to Office 365, however it doesn't support the current version we are using which is 2010.

Does anyone have any suggestions on an easy way to transition from 2010 to 365 (other than don't bother).

I tried a similar exercise in converting an access 2007 database to 2010 and it was a nightmare, I received hundreds of errors when trying to import or copy tables, forms, etc...

VBA scripts seem OK but any macros kick up all sorts of problems.
 
First of all there is no easy path to convert a Desktop Database to an Access Web App (Access 365), see...
http://www.access-programmers.co.uk/forums/showthread.php?t=241257

And it's not don't bother it's you can't without much modifications, such as turning ALL your VBA to Data Macros because no VBA in Access Web Apps. Now, if you plan to get Office 365 and Access 2013 Desktop you can, depending on which version of Office 365, use a Hybrid database, see...
http://www.devhut.net/2014/01/13/ho...access-database-in-office-365-azure-database/
 
Thanks for your help
 
@Jaye7: you do not have to convert to web app to use A2013. If you are happy with A2010 stick to it. A2013 (desktop) have many limitations: check the other posts on the subject...
 
Thanks for your reply.

I would prefer to stay with 2010 but unfortunately my boss wants to update to 2013.
We have some databases that were made in the 2007 version, which we have to update to 2013 as well.

Around a dozen front ends and a dozen back ends.
At least the back ends are easy, except that you need the new front ends before you can use them.
 
Why would you need a new Frontend? Databases created in 2007 will run in 2013.
 
Access 2007 and 2010 won't run in 2013, when you try to open the database it gives an error message saying something like "can not open a previous version"
 
Hmm, not having that problem. What References do you have set?
 
Access 2007 and 2010 won't run in 2013, when you try to open the database it gives an error message saying something like "can not open a previous version"


I run 20903 mde, 2007/2010 create accde in Access 2013 without any issues.

From the error I suspect hat you have renamed the .accdb/.accde to a .accdr. Is that correct? If yes, try renaming back to a .accde or .accdr. Does it run after renaming?

My boss wants us to upgrade Access on our terminal server to Office 365, however it doesn't support the current version we are using which is 2010.

There may be a licensing issue with the keys from the Office 365 plan when installing it on a terminal server. Normally you purchase Office 2013 Professional Plus (exact same thing as with Office 365) but through a Volume Licening. I would check with the vendor you used to get Office 2010 for the terminal server.


Office 365 is just a subscription plan to a suite of services, which usually includes Office Professional Plus for the desktop.

With all the Office 365 plans that include the desktop apps you get Office Professional Plus the full office suite). Depending on the plan how many licensees a user gets to install on their multiple devices, not multiple users.

What Office 365 subscription plans do provide is other hosted services that you may not need.

To get Office 2013 Professional Plus you have to options.
1) Regular retail version - single copy or Volume License (VL)s.
2) Office 365 subscription (which has a license to install on 3 to 5 of the user's devices (laptop, desktop, etc) depending on the plan.)

Either way you get the exact same desktop software. The only difference is the license type.

It appears what people are getting confused when they hear Office 35 when related to access as meaning web database. Unless you have a sharepoint server (could be through Office 365 then a web database becomes an option. But is is definitely not a requirement with Office 2013 through a from Office 365 subscription.

For small business with less than 10 computers and home users the most cost effective way to get Office is through the Office 365 subscription. It give small business the same centerpiece level computing at a very low cost.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom