How to delete or edit a Machine Data Source type DSN from the ODBC Select Data Source window.

MLH

Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.

Jan 16 '08 #1

Subscribe Post Reply

17422

Tony Toews [MVP]

MLH <CR**@NorthState.netwrote:

>Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.

Not sure about your exact answer but consider going DSN less.

I much prefer DSN-Less connections as it is one less thing for someone to have to
configure and one less thing for the users to screw up. This is also better for
Citrix/TS farms where each individual system would have to have a DSN created and
maintained.

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.carlprothman.net/Default.aspx?tabid=81
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Jan 16 '08 #2

Tom van Stiphout

On Tue, 15 Jan 2008 20:47:26 -0500, MLH <CR**@NorthState.netwrote:

Control Panel Administrative Tools ODBC "Remove" button.
-Tom.

>Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.

Jan 16 '08 #3

Similar topics

Edit Command Problem

by: Steve Bishop | last post by:

I have a form with a search text box and a grid that displays the results. Within the grid, I have edit command links set up to response.redirect to another page that puts the DataKey value in the...

C# / C Sharp

one page to edit, delete, and add data to a database

by: Qnavry | last post by:

I am creating one page to edit, delete, and add data to a database. The Add code works but the Edit and Delete do not. What am I doing wrong? If you need more code let me know. Thanks Code:...

ASP.NET

Can't edit, delete or add row in an Access database in a website 2

by: dennist685 | last post by:

Can't edit, delete or add row in an Access database in a website 2003 When I implement a walkthrough using Northwind I have no trouble doing this. Also, in a windowsforms project I have no...

ASP.NET

cannot delete or edit inserted records ( via detailsview) in gridview

by: Marc | last post by:

Hi, I made a detailsview for inserting records. I also made a gridview for editing and deleting the same records. The keyfield is an autonumbering field in Access (pcnr). My problem is: I can...

ASP.NET

Viewing machine data source names

by: zdrakec | last post by:

Hello all: I want to present my user with a list of all system data source names (System DSN) that are defined on his machine that are of type MS Access (.mdb). However, I am having some trouble...

Visual Basic .NET

Ajax-How to create delete button for each record after search

by: bluez | last post by:

I want to design a webpage where user can search the data from the database and list out the related records. Each of the record got a delete button which allow user to delete the record. ...

Javascript

Publishing Access Data on the Web

by: ADezii | last post by:

There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no...

Microsoft Access / VBA

Delete row in GridView problem

by: William LaMartin | last post by:

On webform, I am populating a GridView from a SQLDatasource based on a MySQL table named PIB. There is no vb code involved. Everything is done in the source for the aspx page, provided below. ...

ASP.NET

Details View doesnt work with Delete Or Update

by: JustRun | last post by:

I have a problem with the select option at the gridview and gonna pull my hair out cause it doesn't work at all. Here is the Grid view code: I want to get the selected row when the user click...

.NET Framework

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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...

Windows Server

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,...

C / C++

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...

General

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,...

Career Advice

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...

Microsoft Access / VBA