Relinking FE to BE programatically

W

Westeral

I have databases both BE's and FE's in several locations throughout the state
(Michigan) and when I change the FE I send the new one to each office and
they just copy over the old one. This works well for those who have the same
path that I have at my office that I develop at. However, several of these
locations the path is different to the back end and I cannot even replicate
it here as I don't have some of the drives mapped as they do and I am not
allowed to map drives myself. I have set up the front end to use the Relink
Access tables from code from The Access Web and it works fine but it runs
even when the links to the BE are correct. I would like to run it only when
the tables need re-linking. Is this possible? Right now I run the code from
a startup form on the Close method using the following code;

Private Sub Form_Close()
If fRefreshLinks = False Then
MsgBox "You have not refreshed the database links. This application "_
& "will not function and will be terminated."
DoCmd.quit
End If
End Sub

I am developing in Access 2002 and the users I send to create spreadsheets
each month that are created programatically and send to a central location
for import. Many of these users are extremely computer illiterate and I have
to walk them through relinking over the form (sometimes painfully doing so).
The fewer messages they see on the screen the better so if I can set it up so
they only have to re-link (when I send a new FE), the more sane life will be
for me. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top