autoupdate Front End

[MarVitAlex]

sorry you only need to add tblLocalVariables to your FE.

here is an alternative steps.
(setup on you computer)

1. create a "permanent" folder for your FE.
example, create a folder on you pc and put
the FE there:

c:\accDatabase

Hello arnelgp!
Нow can environment variables %USERPROFILE% or %HOMEDRIVE%%HOMEPATH% be used to FRONT END Location on CLIENT:

%USERPROFILE%\Documents\Access\database_fe.accdb

I have tried %homedrive%%homepath%, however an error is returned:

 

[Gasman]

Use the Environ() function.

 

[MarVitAlex]

Use the Environ() function.

Thank you, Gasman!
Everything worked out with this function.