May 29 2020 06:21 AM
I have an Access 2000 .adp application that uses VBA functions like Trim, DateDiff etc. Using Access 2010 with the unencrypted application all the functions work properly (All the References are present). However, when I encrypt the application and use the encrypted version the functions are not found. This problem only appears on 2 of 30 machines. Any ideas what I need to do to these 2 computers?
May 29 2020 06:59 AM
For starters, ADPs have been deprecated for quite a while so continuing to use them poses some risk in any case.
The most likely problem is that the 2 problem computers have different versions of Access. Have you confirmed that all of your computers, including the one on which you perform the encryption, have the same version of Access with all updates applied?
And by "encryption" could you clarify how that is done?
Jun 04 2020 05:21 AM
The 2 problem computers (as well as most of the other 28) use Access 2010 Runtime.
As I mentioned, the application was originally written using Access 2000. It is encrypted by opening the application in Access 2000, compiling it then going to Tools; Database Utilities; Make an .ade file.
Jun 04 2020 07:46 AM
@dpindy Thanks for the clarification. You are creating an .ade from an.adp then.
The problem may be that the 2 computers in question have been updated with newer versions of Office. I