Disconnecting Access Database

Results 1 to 2 of 2

Thread: Disconnecting Access Database

  1. #1
    Join Date
    Dec 1969

    Default Disconnecting Access Database

    Hello.<BR>I was testing an ASP page with database access and there was an error on the page, so it did connect to the database but it didn&#039;t disconnect. Now I&#039;m trying to disconnect the database, but I don&#039;t know how!. I&#039;m running my website in a Interland Server.<BR>Can you help me? Thanks a Lot!<BR>Fugas

  2. #2
    Join Date
    Dec 1969

    Default RE: Disconnecting Access Database

    I think we found the answer to this in Access Help, by searching under ADO Connection.<BR><BR>Try this code, it seems to work...<BR><BR>&#039;conn&#039; is your connection.<BR><BR>if conn.state="adStateOpen" then <BR>conn.close<BR>set conn=nothing<BR>end if<BR><BR>You might need to find a way of trapping the error, to execute this code.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts