What is the best way to handle environments where there are multiple versions of Office/Access and Windows (7/8)?
I have managed to fix the 32/64 bit OS issues but am still having VBA reference issues. All versions of Office are 32 bit.
Is it best to put all the required reference files in a central network location and reference them there? Can I reference MSOUTL.OLB version 14.0 from this central location and have that work with the 2013 version of Office/Access?
I've had this issue in the past but cannot recall how I resolved this. I use a batch file to copy the front-end to the user's local machine each time they invoke the application.
Should I put some code in the batch file to copy these appropriate files to the user's local machines?
I would appreciate any direction/assistance you can provide.
Thanks a lot!