I have a database (2003 version) that is distributed to users accross the globe running all running on different OS, MS office versions etc
Most users will use MS Access runtime to work with the program.
The problem I have is that for some advanced features, certain references are not present on some users PC's as the might have office 97 iso 2003 etc.
Often the database won't open telling certain users that there is a missing link or reference and will shut down.
As the reference are just for some advanced functions with the program, most users will not need to use them.
Is there a way I can trap the missing link/reference so that the program will open and execute all functions & subs which don't require the missing references?
Most users will use MS Access runtime to work with the program.
The problem I have is that for some advanced features, certain references are not present on some users PC's as the might have office 97 iso 2003 etc.
Often the database won't open telling certain users that there is a missing link or reference and will shut down.
As the reference are just for some advanced functions with the program, most users will not need to use them.
Is there a way I can trap the missing link/reference so that the program will open and execute all functions & subs which don't require the missing references?