Killing DAO connection..

[Javier Noriega]

I want to disconnect from an Oracle database so I can connect with another user & password -same dsn - but VB seems to keep the old connection and doesnt change to the new use/passw.. anyone has done this before?

Thanks in advance!

Do you close Database and all Recordset objects this way:

rs1.Close
set rs = nothing
rs2.Close
set rs2 =nothing
'.
'.
db.Close
set db = nothing



This steps should kill your current connection and clear memory
Vlad