Bruce H. Johnson
bhjohnson at verizon.net
Wed Jul 18 11:47:35 CDT 2007
Hopefully I'm not being condescending. If this is for your machine only: Control Panel > Data Sources (ODBC) If you need it programmable: HKLM\Software\ODBC\ODBC.INI HTH Bruce H. Johnson Sylmar, CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, July 18, 2007 7:24 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] DSNs I am working with Access as the FE to processing orders where I need to export to a fixed width file because Access stores the format, which is convenient until I come up to speed on how to do something similar in SQL Server. The issue is that the DSN is specific to a database name. How can I edit that to point to a different database? John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.8/906 - Release Date: 7/17/2007 6:30 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.8/906 - Release Date: 7/17/2007 6:30 PM