Run Code or Macro when DB is open

[Gary Hull]

using Access 2007

thanks for your help

 

[Arvin Meyer [MVP]]

Use an AutoExec macro or a startup form. If you use a shortcut to start a
specific Access database, you can also use the /x switch to start a macro,
or the /cmd switch to run a command. I am not sure these last 2 options are
still available in Access 2007 since I haven't used them at all in 10 years.

 

[Arvin Meyer [MVP]]

I am using the code by Dev Ashish to make sure my link my backend DB to my
front end DB. should I run this code when I open the front end DB?
If so what is the best approch

Check if it needs to be refreshed first. If so use an autoexec:

Action: RunCode
Argument: the function's name

or just run it as a startup form in the database.