Thank you John and Andrew too...it's really nice to have a conversation with experts like you...
Yes i've made a confusion here when gave an OLEDB provider for example, i think the right string con. would be (Driver=ODBC,....), but my point is at "Open" part of the code, i just want to make sure that refreshing linked tables is not the same as "re-open" a new connection, and i have already clearly explanations from you.
I always do the trick that Andrew had explained, but only to mdb/accdb BE and for single user local PC, is that "wise" to use that trick to ODBC linked tables in multi user environment? i imagine ... let say about 50 users FE do that trick to sql server/mysql on a server through internet conection, the 50 user keeping connect to the server at the almost same time...
Regards
Hendra Agestha
--------------------------------------------
Pada Sel, 11/3/14, John Viescas <JohnV@msn.com> menulis:
Judul: Re: [MS_AccessPros] Re: Refresh a Linked table
Kepada: MS_Access_Professionals@yahoogroups.com
Tanggal: Selasa, 11 Maret, 2014, 4:12 PM
Andrew-
Good advice. Actually, I *always* recommend
leaving a recordset on a linked table open for the duration
of the app. Access will re-use the already established
connection. If you keep opening / closing stuff
without keeping the connection, Access has to go through the
overhead of re-building the connection each time - a
time-consuming task. It's more for performance
reasons than just checking the connection.
John Viescas,
AuthorMicrosoft Access
2010 Inside OutMicrosoft Access
2007 Inside OutMicrosoft Access
2003 Inside OutBuilding
Microsoft Access Applications SQL Queries for
Mere Mortals http://www.viescas.com/ (Paris,
France)
On Mar 11, 2014, at 10:02 AM, <yahoo@craven.de>
<yahoo@craven.de>
wrote:
Hi Hendra, you're welcome.
John has answered your Question more clearly than I might
have. There is however one point I'd like to make, using
ADO with a connection string specifying the OLEDB Provider
is not going to influence the ODBC Connections. It is also
important to note that you started the conversation linking
in tables from an MDB source and this is neither ODBC nor
OLEDB which alters the discussion (sorry to complicate
things again...)
One common trick presented around here is to keep a
connection open to a small table in each of your databases
you link to. If you have problems with dropped connections
then this trick is said to help but in any case you can do a
query on this/these connections from time-to-time or prior
to doing any real work.
Yours,
Andrew
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (13) |
Tidak ada komentar:
Posting Komentar