>What are the other options than using a view or dataenvironment?

SQL Pass Through

>If I use a table won't I have to bind each control on the fly.

You would set the controlsources in the property sheet just the same.