Link Refresh Code

[salmonella]

I need to ask you some questions about the code below that you posted .I tried it and it is not working. can you, or anyone else that uses this code, reply to this- thanks!!!

On Error GoTo refresh_err 
    Dim daoDB As DAO.Database 
    Dim tdef As DAO.TableDef 
    Dim strConnectOld As String 
    Set daoDB = CurrentDb 
    Set tdef = daoDB.TableDefs(strTablename) 
    strConnectOld = tdef.Connect 
    tdef.Connect = strConnectOld & "; UID=" & strUserName & "; PWD=" & strPassword 
    tdef.RefreshLink 
    tdef.Connect = strConnectOld 'restore no-password version of connect string 
    fODBCTablesRefresh = True 
    Exit Function 
refresh_err: 
    fODBCTablesRefresh = False 
End Function

** Edit **
This thread was split from Run an AutoExec Macro where an ODBC password is required. There may be some relevant content there.

[NeoPa]

Please refrain from posting your own requirements in someone else's thread. This is thread hijacking and is not allowed on this site.

Moving on, we can probably help you, but it's a good idea to include your questions when you post ;)

Hit us with the questions and we'll help where we can.

[Stewart Ross]

As the author of the function all I can say is that it is in use every day just as it was presented in the original thread. It is intended for auto-refresh of ODBC connections.

The function requires the ODBC connection username and password passed in as parameters (variables strUsername and strPassword). It also requires the name of one of the linked tables from that database (variable strTablename). If any one of these is missing or is incorrect either the connection will not be established or the table (and therefore the link as a whole) will not be refreshed.

Assuming it is an ODBC connection you are refreshing, the first thing to establish is are you passing the parameters correctly, bearing in mind that it is not the USER'S username and password but the CONNECTION's username and password which has to be passed to the function?

You will need to use the VB editor's debugging facilities to set breakpoints and test values. If this is something you have no knowledge of or cannot do then it is unlikely you will have sufficient understanding of what the function is doing to adapt it to your own needs.

-Stewart

[salmonella]

Sorry about the 'Hijacking' have never heard of this and will NOT do it in the future.

Took your advice and looked at the string again, the problem was that the constring used pwd and uid instead of 'password' and 'user'. Works fine now.

thanks!!!!

[NeoPa]

Good to hear (both about the hijacking and certainly that you got the problem resolved).

Welcome to Bytes!