[AccessD] DSNs

John,

1. Have multiple DSN's defined and switch the .Connect property to point to
the correct one.
2. Redefine a single DSN.
3. Provide all the connection information in the .Connect property and go
DSN less.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, July 18, 2007 10: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