Linked table manager error

[leerlap]

I have what I thought was a simple question, but can't seem to find an answer to. I'm using access as a front end to a back end SQL database. I have all my tables linked, but I'm still in development and keep needing to change my sql tables slightly. It was my understanding that in access, all i'd need to do is click the "linked table manager" and I could refresh my links. However, when i click this, i get this error:
"[file name] can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. The wizard you need may be missing from the Libraries key of the [file name] section of the Windows Registry. To make sure that the wizard is in the Windows Registry, run Setup to reinstall [file name], and then compile all Visual Basic modules in the database."

I've tried compiling the file and reinstalling access, but those didn't work. Any help in getting past this? Thanks for your help.
Lee

 

[ByteMyzer]

If you did not select the Microsoft Access Wizards upon installing Microsoft Office, it is possible that this is why the Linked Table Manager will not come up. However, here is a piece of VB Code that will do the same thing:

Public Sub RefreshLinks()
On Error GoTo RefreshLinks_Error

Dim X As Integer, tbds As TableDefs

Set tbds = CurrentDb.TableDefs

For X = 0 To tbds.Count - 1
    Select Case tbds(X).Attributes
        Case dbAttachExclusive, dbAttachSavePWD, dbAttachedTable, dbAttachedODBC
            tbds(X).RefreshLink
    End Select
Next X

Exit Sub

RefreshLinks_Error:
    MsgBox Err.Number & ":" & Err.Description, vbCritical

End Sub

From the Debug Window, type:
RefreshLinks
...and press Enter. This will refresh the links on all linked tables in the current database.