Execute function at database startup - how?

[SueBwork]

Hi. I want to execute a routine, at database startup time, to relink
the backend tables. I have the code for the function, but I don't know
where to invoke it. I tried putting a call to the function in the Open
Event of the MainMenu (which gets displayed at Startup). That seems to
be too late, because I get an error that says that it can't find the
tables (I moved the backend file to a different folder, for testing of
this function).

What event is "kicked off" when the database starts up?

Regards,
SueB

 

[Rich]

Use an autoexec macro and please delete the duplicate post

 

[SueBwork]

Rich,
Thanks for the suggestion. About the duplicate post ... my apologies. The system went weird here at work and I wasn't sure if it got posted. I'll see if I can delete it (don't know how...but I'll search around for a delete option somewhere). Thanks, again.
SueB

 

[Oldsoftboss]

You need to store the back end path in a local table, not a linked table. Create a "splash" screen that does not have a record source. In th On_Timer event call the Re-Linking function then close that form and open your main menu.

Dave

 

[Oldsoftboss]

Like this....