Solved

new database connection access

Posted on 2012-04-13
2
188 Views
Last Modified: 2012-04-13
hi can anyone tell me how to edit an dsn (datasource connection in access)

i want to point to a new databases on same server
0
Comment
Question by:ac_davis2002
2 Comments
 
LVL 10

Accepted Solution

by:
gavsmith earned 500 total points
ID: 37842020
A dsn is a file based odbc connection which you can edit by going to Control Panel -> Admin Tools -> Data Sources (ODBC) click the 'File DSN' tab browse to you dsn file and click the configure button.

Hope that helps
0
 
LVL 6

Expert Comment

by:wshark83
ID: 37842036
go to control panel, Administrative Tools, Data Sources (ODBC)...

select the dsn name and then configure
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL 2012 AOG and SQL2014 AOG 76 61
SQL- GROUP BY 4 25
SQL Syntax 6 42
Why do I get an error when executing a stored procedure using SQL Server 2008? 1 8
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question