Hello,
I have an accdb file created with Access 2016 which contains some custom functions in standard modules.
This file is converted to accde format and used as a reference to a second accdb file also created with
Access 2016 which contains forms,reports, tables etc.
For clarity, let's assume that the first file is named A.accdb. This file is converted to A.accde
The second file is named B.accdb. So, A.accde is referenced by B.accdb
In B.accdb, I have created a select query that uses the custom function 'test' which is defined in A.accde
Both files (A.accde and B.accdb) are deployed to user machines with access 2016 runtime version.
In one of these machines the user gets the error "Undefined function 'test' in expression" when the query
in B.accdb that utilizes function 'test' is executed.
This error does not occur if B.accdb references A.accdb instead of A.accde, however the file A.accdb
cannot be distributed to the end user.
Moreover the user machine has full Access 2007 installed
Could you please provide any guidance on how to resolve this situation?
Thank you very much in advance.
Best Regards
I have an accdb file created with Access 2016 which contains some custom functions in standard modules.
This file is converted to accde format and used as a reference to a second accdb file also created with
Access 2016 which contains forms,reports, tables etc.
For clarity, let's assume that the first file is named A.accdb. This file is converted to A.accde
The second file is named B.accdb. So, A.accde is referenced by B.accdb
In B.accdb, I have created a select query that uses the custom function 'test' which is defined in A.accde
Both files (A.accde and B.accdb) are deployed to user machines with access 2016 runtime version.
In one of these machines the user gets the error "Undefined function 'test' in expression" when the query
in B.accdb that utilizes function 'test' is executed.
This error does not occur if B.accdb references A.accdb instead of A.accde, however the file A.accdb
cannot be distributed to the end user.
Moreover the user machine has full Access 2007 installed
Could you please provide any guidance on how to resolve this situation?
Thank you very much in advance.
Best Regards