Refresh table ODBC link

[TheunsGoosen]

Hi,
I linked a table to an ODBC and it works perfectly but the moment I close Access and click on the table to display the info- the following message appears “The ODBC connection to SQL server failed” To reestablish the connection I click on the table and the “Link table manger” ….this cannot be right, because the next step is to create user forms that will not allow the user to access the tables, how do one establish a permanent ODBC connection.

Regards
TheunsGoosen

 

[nickdel]

Your not making any changes to the SQL Server DB in between are you? This is the most likely cause but not the only!

Let me know and I'll have a think in the meantime!

Cheers

Nick

 

[TheunsGoosen]

No, no changes to the tables, i just linked(import) two tables from the ODBC and in access i wrote a query that is making use of the two tables, and the query works perfectly...but the moment i close and reopen the data base and click on the query or the linked tables a microsoft message diplays that the ODBC connetion to SQL server failed, and not even asking me for a password to reestablish the connection

 

[PHV]

Did you tick the remember password checkbox when you created the linked tables ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheunsGoosen]

Sounds like the remember password checkbox can help, but i don't seem to find or see that checkbox?

 

[TheunsGoosen]

Got it, works perfectly.
Thanks