Develop in Office 365 for an Access 2013 user?

[Bob C_0557]

I was hired on a short-term project to convert a few spreadsheets into a few Access databases. I have Office 365 (64 bit) with Access, the company has Access & Excel (32 bit) 2013.

I know I will have issues with the VBA - 32 vs 64, and I know how to handle. I don't think multi-value fields were available back then, but don't use them anyway. And I do know that I have references they don't have. But as of now fortunately there are only 4 (But I think there will be more).

#1. Will they be able to use my databases on Access 2013?
#2. Any other issues I need to consider?



Thanks!

Bob C

[orange]

Welcome Bob C. You may find some info in the Similar Threads at the bottom of the page.

You may want to get a copy of the AccessVersion and Reference checker Addin (by Isladogs). This will tell you about different versions users may have on their machines and also show current/missing references.

[isladogs]

Hi Bob
I'll answer here rather than to the email you sent me earlier
An ACCDB database crested in Access 365 will probably work in Access 2013 as long as it doesn't include features added in later versions such as modern charts or support for large numbers.
Reference version issues will occur if you have references to e.g. Excel or Word. Using late binding will solve that issue.

If you distribute as an ACCDE there may be additional issues.

Suggest you test in a runtime version of A2013 or better still get hold of a full version for testing purposes
Good luck

For info, the dreaded MVFs were added in Access 2007

[Bob C_0557]

Thanks! Much appreciated. And love the idea about testing using a 2013 runtime version!

[isladogs]

You're welcome. For info, my add-in mentioned by @orange gives output similar to this:

Access / Windows/ Office Version Info
=====================================

Date/Time: 13/09/2022 20:29:14
Workstation Name: COLIN-LAPTOP
Windows Build: 10.0.19042.1706
Operating System: Windows 10 Home Version 20H2 - Build 10.0.19042.1706 64-bit
Access Build: 16.0.15601.20088
Access Full Version: Access 365 Version 2208 - Build 16.0.15601.20088 64-bit
Access Path: C:\Program Files\Microsoft Office\root\Office16\
Office 365 Installed: Yes
Office Install Method: Click-to-Run
Update Channel: Current Channel
Update Option: ENABLED: Updates are automatically downloaded and installed

If used as an add-in, it also lists the VBA references used in the selected app

[Bob C_0557]

Thanks, I downloaded both the 32bit and 64bit but haven't had time to try the 64 bit.