473,405 Members | 2,310 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Fixing table links with ADO

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
5 1279
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
"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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Robin Mason | last post by:
Hi, I've got a table which has a set of links down the first column, each of which is in their own <TD>...</TD>. In the second column, I have one td which spans down the side of the links which...
8
by: Andrew Ayre | last post by:
Hi, I have the following table layout: --------------------- | A | E | ------ |
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
2
by: Mark | last post by:
Hi there I have one table. It is called links and looks like this: <table id="links"> <!-- loop --> <tr> <td width="50%">item 1</td> <td width="50%">item 2</td> </tr>
4
by: Neil Ginsberg | last post by:
I have ODBC linked tables to a SQL 7 database in an A2K database. The linked tables do not have the password stored in them, so the first time the user accesses them, they need to enter the SQL...
2
by: Patrick Olurotimi Ige | last post by:
When i run the code below with stored proc :- I get only the first table results :-"templates" even if i fill the dataset with another table for example category,pages etc.. Any ideas? ...
5
by: JackM | last post by:
I need a little guidance putting a script together. I'm trying to read a list of image links from a text file (not a database) and display them in a table on my page. I want to display them in rows...
7
by: Adam | last post by:
Hello. I do most of my web dev work from a Mac (whose file system is case-insensitive.) I upload my web pages and other files onto a Unix-based host, which is case sensitive. When I look at the...
2
by: metomeya | last post by:
My links bar in IE is pointing to the Favorites folder, instead of the Links folder........ Is there a regedit fix to this?
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.