MS Access odbc_close() Dosn't work

Just a note. If you ever plan to use Access as a database engine for a project, (I know, I know why would you), be aware the command odbc_close() does not work. As a test do this
connect to an Access database through odbc.
run query, get results display results.
call odbc_close()
run another querry on the supposedly closed db.
get the results and display them.

You will see the connection is still alive and leakes memory when your script closes.

Beware..

This has come up before. I think the problem is that odbc_close() fails if there are open transactions for the connection. Use odbc_free_result() on any result resource you have open, and then call odbc_close().

I Tried it, dosn't work. Try this
1.open a connection to the db
2.close the connection
(there was no transaction thus no result thus no need for free_result)
3. do a query on the database and get the results

The query will still work. even though the connection should be closed.

I have no idea why that would be failing. Have you tried using odbc_close_all().