Hendra-
No, they're different.
RefreshLink does:
1) Establish a connection to the database
2) Fetch and refresh the local definition of the table.
3) Disconnect
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Mar 10, 2014, at 5:39 PM, Agestha Hendra <agesthahendra@ymail.com> wrote:
> Thank you John,,, so refreshing link doesn't mean similiar like this ? :
>
> Dim conn As New ADODB.Connection
> conn.Open "Provider=SQLOLEDB;SERVER=ASUS-PC\SQLEXPRESS;UID=user;PWD=MyPWD;DATABASE=LAT"
>
> Regards
> Hendra Agestha
> --------------------------------------------
> Pada Sen, 10/3/14, John Viescas <JohnV@msn.com> menulis:
>
> Judul: Re: Bls: [MS_AccessPros] RE: Refresh a Linked table
> Kepada: MS_Access_Professionals@yahoogroups.com
> Tanggal: Senin, 10 Maret, 2014, 7:21 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hendra-
>
>
>
> That's not likely to help at all. RefreshLink simply
> re-fetches the table definition from the back end and makes
> sure the connection can be made. As soon as it is finished,
> the connection is dropped. The likely culprit in your case
> is problems in the network you're using. ODBC
> connections are "weak" only because they fail if
> the line hiccups.
>
>
>
> John Viescas, Author
>
> Microsoft Access 2010 Inside Out
>
> Microsoft Access 2007 Inside Out
>
> Microsoft Access 2003 Inside Out
>
> Building Microsoft Access Applications
>
> SQL Queries for Mere Mortals
>
> http://www.viescas.com/
>
> (Paris, France)
>
>
>
> On Mar 10, 2014, at 11:57 AM, Agestha Hendra
> <agesthahendra@ymail.com> wrote:
>
>
>
>> Thank you Andrew...why do i want to refresh a link
> table, because i've read several discussions about
> "interupted/Dropped ODBC connection in the midle of a
> process...(i think it means to long process)" or
> something like that,,,and they said that is a weakness of
> ODBC connection. So i think "refreshing a linked
> table" (before execution) would much help for this, not
> all the linking tables in the FE, just the table that we
> want to process...what do you think about it?
>
>>
>
>> Regards
>
>> Hendra Agestha
>
>> --------------------------------------------
>
>> Pada Ming, 9/3/14, yahoo@craven.de
> <yahoo@craven.de> menulis:
>
>>
>
>> Judul: [MS_AccessPros] RE: Refresh a Linked table
>
>> Kepada: MS_Access_Professionals@yahoogroups.com
>
>> Tanggal: Minggu, 9 Maret, 2014, 11:00 PM
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>> Hi Hendra,
>
>> The same restriction applies to the QueryDefs
> collection,
>
>> you can only change the SQL or Connect if you
> assign/create
>
>> a QueryDef object and then manipulate the parameters,
>
>> otherwise they are readonly.
>
>> In my experience, you don't normally need to do a
>
>> RefreshLink after changing the Connect string (at least
> with
>
>> Linked SQL Server Tables), it might however be
> "best
>
>> practice" to do so.
>
>> Yours,
>
>> Andrew
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>> ------------------------------------
>
>>
>
>> Yahoo Groups Links
>
>>
>
>>
>
>>
>
>>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar