ACC or UH?

Ignoring my previous post, I spent my first year at UTSA for the cap program but unfortunately was unable to complete it due to making a D in sociology (I forgot one online exam) despite making A’s and B’s for the rest of my courses. At this point, would it be best to spend the upcoming semester at Austin Community College and attempt to transfer to UT again from there or just go back home to Houston and spend the rest of my college career at UH? Thanks xx