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
>
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar