Forum Discussion
dpindy
May 29, 2020Copper Contributor
Missing functions in Encrypted Access Application
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 pres...
George Hepworth
May 29, 2020Steel Contributor
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?
- dpindyJun 04, 2020Copper Contributor
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.
- George HepworthJun 04, 2020Steel Contributor
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