BE/FE - refresh links at startup

[Ryko]

Hi

I have a database split FE/BE

At startup switchboard pops up, however when back end database is no longer where it should be it only returns a message "could not find file ....".

I have a form for user to select where BE dbase is located which will then automatically refresh links to all linked tables. Is it possible for this form to pop up whenever BE is relocated? How would I invoke this at startup?

Thanks for your help.

 

[KeithG]

You would have to trap the error.

 

[Ryko]

Fair enough. I've tried the switchboard form on open with little success. How and where could I do it? thanks.

 

[RuralGuy]

Don't open any tables until you have located the BackEnd. I use the Dir() function to look for the BackEnd.

 

[Ryko]

So I guess I should avoid switchboard at startup then? Maybe run an AutoExec macro which will open the one form used to repair a broken BackEnd db link if DoCmd.OpenForm("Switchboard") generates an error?

 

[RuralGuy]

I forgot that the switchboard needs a table to run however there is nothing special about the SwitchBoard form. Use the Open event of the SwitchBoard form to look for your BackEnd first. There are several ways to solve this particular problem. I use the AutoExec macro to open a hidden form first so I can do housekeeping functions and load my other forms from there.

 

[Ryko]

I've tried setting SOMETHING up in the Switchboard Open event, close, but no cigar. I'm no expert, however. AutoExec macro seems to work fine though - I created a function in a module that opens the switchboard but when on error it opens a form to locate a BackEnd db and update links. So far, so good. "Don't open any tables until you have located a BackEnd" was a good pointer. Thanks, RG.

 

[RuralGuy]

Glad I could help. I don't use the switchboard so I'm a little rusty on it. Glad you got thhings sorted. It sounds like you are over this hump.