Updating from Access 2013 to 365? (2 Viewers)

GBalcom

Much to learn!
Local time
Today, 15:24
Joined
Jun 7, 2012
Messages
462
Hello,
We've been stable on Access 2013 for a long, long time. We are a small business but have many business critical access apps (32 bit), that I've made, heavy in VBA, and compiled .accde front ends. We use these on our front office machines with MS office, as well as shop machines that utilize 2013 runtime. We're looking into upgrading office to 365 to solve a different issue. I've heard that with 365, MS Access has updated "modern charts" available. Does Access 365 have a runtime version? I don't know a lot about 365, but it seems the access is still a PC program correct?

What potential headaches could I be faced with? Thanks for any help in advance.
 
Yes you can get a runtime for 365 access but a full version is included in most versions of office

Ensure you install the 32bit version as 64bit is now the default

If you decide to install 64 bit ensure you have a full version for development purposes - you will need to make some changes to API calls and some dimmed types- some longs become longptr. Plenty of advice on this forum and elsewhere

Other thing to watch out for - if your apps work with outlook, ensure you install the classic version. The new version is completely different and you have to do things in a completely different way
 
Last edited:
Yes you can get a runtime for 365 access but a full version is included in most versions of office

Ensure you install the 32bit version as 64bit is now the default

If you decide to install 64 bit ensure you have a full version for development purposes - you will need to make some changes to API calls and some dimmed types- some longs become longptr. Plenty of advice on this forum and elsewhere

Other thing to watch out for - if your apps work with outlook, ensure you install the classic version. The new version is completely different and you have to do things in a completely different way
Thank you CJ_London,
Is there any real difference (speed or otherwise) between 64 bit and 32 bit? My programs run fairly well as is, not sure it would be advantageous to switch them unless we're eventually forced to.
 
I don't think there are a real speed difference on most of databases. CurrentlyI install x64 on my clients but there is no real improvement on my applications.
 
Last edited:
64-bit has improved memory handling and will be better for very demanding tasks. Otherwise 32-bit will be fine
 
Thank you CJ_London,
Is there any real difference (speed or otherwise) between 64 bit and 32 bit? My programs run fairly well as is, not sure it would be advantageous to switch them unless we're eventually forced to.

There is not much of a speed difference except for cases where you have exercised the option to define external libraries ("references"). Not all 32-bit libraries have 64-bit counterparts. If you are using "plain vanilla" Office stuff, you would most likely be OK, but there is extra work involved in setting up for a mixed environment. The speed difference might be just a speed bump in upgrading the code for mixed environment, or it might be a "dead stop" if some library in question won't work at all in the mixed environment.

It is true that Access/64 has improved memory management, but you still have the same size limitations of 2 GB for an Access app file. If you don't need Excel/64 or Word/64, which CAN get very big very quickly, I would stick with Office/32.
 

Users who are viewing this thread

Back
Top Bottom