By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

Fixing table links with ADO

P: n/a
I've seen several very nice routines on various web sites to fix table
links when a file is moved. So far all the ones I've found have used
DAO. Anyone know of a sample of such a routine that uses ADO?

Thanks,
Randy
Oct 26 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
What is the point, table links are ODBC connections anyway.

--

Terry Kreft
"Randy Harris" <ra***@no.spam.netwrote in message
news:1q********************************@4ax.com...
I've seen several very nice routines on various web sites to fix table
links when a file is moved. So far all the ones I've found have used
DAO. Anyone know of a sample of such a routine that uses ADO?

Thanks,
Randy

Oct 30 '06 #2

P: n/a
"Terry Kreft" <te*********@mps.co.ukwrote in
news:A8********************@eclipse.net.uk:
"Randy Harris" <ra***@no.spam.netwrote in message
news:1q********************************@4ax.com...
>I've seen several very nice routines on various web sites to fix
table links when a file is moved. So far all the ones I've found
have used DAO. Anyone know of a sample of such a routine that
uses ADO?

What is the point, table links are ODBC connections anyway.
Er, only if they are links to an ODBC data source. If they are links
to a Jet MDB, they aren't ODBC at all, because Access can't connect
to Jet via ODBC. The connect strings are similar, yes, but ODBC is
*not* involved between Access and Jet.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 30 '06 #3

P: n/a
Randy Harris <ra***@no.spam.netwrote in
news:1q********************************@4ax.com:
I've seen several very nice routines on various web sites to fix
table links when a file is moved. So far all the ones I've found
have used DAO. Anyone know of a sample of such a routine that
uses ADO?
This is like asking if your German-to-English dictionary is
available in translation into English.

The question makes no sense. If you're working with Jet data, you
shouldn't be using ADO.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 30 '06 #4

P: n/a
On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:
>Randy Harris <ra***@no.spam.netwrote in
news:1q********************************@4ax.com :
>I've seen several very nice routines on various web sites to fix
table links when a file is moved. So far all the ones I've found
have used DAO. Anyone know of a sample of such a routine that
uses ADO?

This is like asking if your German-to-English dictionary is
available in translation into English.

The question makes no sense. If you're working with Jet data, you
shouldn't be using ADO.
I guess I have no sense. I'm just not smart enough to realize that I
shouldn't be using ADO.
Oct 31 '06 #5

P: n/a
Randy Harris wrote:
On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:
The question makes no sense. If you're working with Jet data, you
shouldn't be using ADO.
I guess I have no sense. I'm just not smart enough to realize that I
shouldn't be using ADO.
Me too! David has told us often enough. Why can't we learn?

Lyle Fairfield

from
http://msdn.microsoft.com/library/de...dacroadmap.asp

Current MDAC Components
These components are supported in the current release. Use these
components when you develop new applications or upgrade existing
applications.

ADO: ActiveX Data Objects (ADO) provides a high-level programming model
that will continue to be enhanced. Although a little less performant
than coding to OLE DB or ODBC directly, ADO is straightforward to learn
and use, and can be used from script languages such as Microsoft Visual
Basic® Scripting Edition (VBScript) or Microsoft JScript®.

--------------

Obsolete Data Access Technologies
Obsolete technologies are technologies that have not been enhanced or
updated in several product releases and that will be excluded from
future product releases. Do not use these technologies when you write
new applications. When you modify existing applications that are
written using these technologies, consider migrating those applications
to ADO.NET.
The following components are considered obsolete:
....
Data Access Objects (DAO): DAO provides access to JET (Access)
databases. This API can be used from Microsoft Visual Basic®,
Microsoft Visual C++®, and scripting languages. It was included with
Microsoft Office 2000 and Office XP. DAO 3.6 is the final version of
this technology. It will not be available on the 64-bit Windows
operating system.
.....

Oct 31 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.