[AccessD] DSNs

>1. Have multiple DSN's defined and switch the .Connect property to point to
the correct one.

I build a new database for each order, thus the reason for editing the DSN

>2. Redefine a single DSN.

In a text editor I assume?

>3. Provide all the connection information in the .Connect property and go
DSN less.

I didn't state it, but these are for linking tables out of the SQL Server
database. 

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Wednesday, July 18, 2007 12:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com