change odbc to oledb

i'm using odbc for all my connection in all forms..the problem is i'm going to list all my tables from database in a form and most of the examples given use the oledbconnection. can i use the oledbconnection only for the form that i use to list all the tables?only that form use oledb.where else other forms use the odbcconnection. if not what should i do if i still wants to use the odbcconnection