How to add an excutable front end of Access to Trusted...

[BittenApple]

Hello team,
I split my database and converted the front end to executable version.

Although, I added the front end and back end folder to trusted location and then I converted the front end to executable (I do have an original copy before making it to read-only file), this question came to my mind how other end users will add their read-only copy to trusted location?


Regards,
BittenApple

[HansV]

What do you mean by executable version? A .accde database?

[BittenApple]

Yes, it is correct.
Regards,
BittenApple

[HansV]

You could set a trusted location in code, if you know the path. See Create/Set Trusted Location Using VBScript.

[BittenApple]

Hello Hans,
Thanks,
Is VBAScript the only solution?
and one more time, thank you for all your support.
Regards,
BittenApple

[HansV]

How will the end users open the database? In the full version of Access, or in Access Runtime?

[BittenApple]

Hans,
What is Runtime or full version?
I split the database and the front end is saved as accde. Is this considered Runtime or full version. Any how, the end user should be able to enter data into tables through front end.
Regards,
BittenApple

[HansV]

If the users have installed Microsoft Office Pro, for example, they have the full version of Access, and they can add the folder containing the frontend to their trusted locations for Access themselves.

[BittenApple]

Hans,
We have Access 2013 and 2016.
Are you saying if they have accde, they can add the folder to their trusted location?
Regards,
BittenApple

[HansV]

Yes, they can. That works the same way in a .accde as in a .accdb.

[BittenApple]

Thanks,