How can i flush the ODBC connections in DBEngine?

[Edwinah63]

i have a series of linked tables in MSSQLServer which i dynamically
link. but i understand that the DBEngine caches the ODBC links which is
causing problems.

How can i flush ODBC connections in DBEngine without closing and
re-opening the database?

i understand i can change the timeout but had a look at the dbengine
object properties and could not see which one to change.

if this is not possible, can i open and close the database
programatically?

any and all code gratefully received.

regards

Edwinah63