Link to home
Start Free TrialLog in
Avatar of Eileen Murphy
Eileen MurphyFlag for United States of America

asked on

Multiple MS Access Versions References

Hi Experts;

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!

Eileen
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Eileen Murphy

ASKER

Hi Pat!!! Thank you for responding. This is not a distributed product so that may simplify this issue.  Since the network environment is static and all users have read/write access to a share -- do you think that moving these references to a share and reference them there would stabilize the situation?

Eileen
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the advice! I appreciate it!