I disagree with the suggestion that the DSN approach is the "best way" to go. It adds another layer of software. The best way to go is to use oledb. See the following for examples http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForMicrosoftJet HTH Ian Ornstein - Programmer and Web Developer IBM Global Services, Global AMS Delivery (704) 509-8022 -----Original Message----- --__--__-- Message: 6 Date: Mon, 9 Apr 2001 18:14:45 -0700 From: John Meyer <john_meyer at geocities.com> To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> Subject: Re: [thelist] ASP & MS Access Reply-To: thelist at lists.evolt.org The best way to accomplish this is through a DSN connection.