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.

 

[Gary Hull]

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.

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

 

[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.