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 (11) |
Tidak ada komentar:
Posting Komentar