Hi I am using a 32 bit computer running Access 2013 32 bit. I compiled a database (accde). At the office there several computers running Access 2010 and 2013 in both 32 and 64 bit format.
The backend is placed on the server and front end are copied to their desktop. There are issues opening the databse you will understand. I cannot create several database to facilitate these version of Access. The question is how to have all version access the database. I downloaded ACCESS RUNTIME x86 (32 bit) and install on some, only few work.
Is there a way I can create a VBA code to check what version running and make necessary changes etc. Have anyone ever worked in such environment and what was done to have it worked?
REgards