Fixing table links with ADO - Microsoft Access / VBA

Randy Harris

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

Subscribe Reply

1297

Terry Kreft

What is the point, table links are ODBC connections anyway.

--

Terry Kreft
"Randy Harris" <ra***@no.spam. netwrote in message
news:1q******** *************** *********@4ax.c om...

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

David W. Fenton

"Terry Kreft" <te*********@mp s.co.ukwrote in
news:A8******** ************@ec lipse.net.uk:

"Randy Harris" <ra***@no.spam. netwrote in message
news:1q******** *************** *********@4ax.c om...
>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

David W. Fenton

Randy Harris <ra***@no.spam. netwrote in
news:1q******** *************** *********@4ax.c om:

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

Randy Harris

On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
<XX*******@dfen ton.com.invalid wrote:

>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

Lyle Fairfield

Randy Harris wrote:

On Mon, 30 Oct 2006 15:05:57 -0600, "David W. Fenton"
<XX*******@dfen ton.com.invalid wrote:

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

Similar topics

2062

fixing td sizes

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 contains the main text on the page. Something like this: |------------------------------|

HTML / CSS

3078

Fixing row heights

by: Andrew Ayre | last post by:

Hi, I have the following table layout: --------------------- | A | E | ------ |

HTML / CSS

24504

How to do a <table> with <div> tag

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 'stretch'</td> <td valign="top" width="300">some data that won't 'stetch'</td> </tr> </table>

HTML / CSS

1606

How to set up a Table

by: Mark | last post by:

Hi there I have one table. It is called links and looks like this: <table id="links">  <tr> <td width="50%">item 1</td> <td width="50%">item 2</td> </tr>

HTML / CSS

18964

Linked Table Password

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 password. I am developing a process that will automatically run at night which will access those tables. I need to be able to give Access the password, as the user currently does, so that the process can run without a password prompt appearing....

Microsoft Access / VBA

2375

getting multiple table results question using stored procedure

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? Store procedure below:- ------------------------

ASP.NET

1998

Need help with my code reading flat file into HTML table

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 of four. I can get my script to work to display the images but I can't figure out how to do two things: 1. How do I get only one image into each table data entry? 2. How do I get it to create blank table data entries for any amount less than 4...

PHP

3320

Fixing case-sensitive file errors? Mac Dev to Unix host

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 errors that were generated on my web site, I find that sometimes people are trying to access, for example, "file.exe", when I uploaded it as "File.exe" with an uppercase letter. Some of these pages and files have had mixed case for years and...

HTML / CSS

1267

Help fixing IE Link bar.

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?

Microsoft Windows

9425

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10230

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10004

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9870

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8886

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7416

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6678

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3576

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2817

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General