Run-time Access DB and Data Environment?

[simpleton]

I believe that creating a database at run-time and using it in the data environment will cause a slight problem with when the DE checks for connectivity to that database. After I create the DB (tables and all), the SQL query that I use for the DE Commandtext line fails b/c it can't recognize the table associated with the database. I know the SQL statement works b/c I used it with a database *not* created at run-time and it worked fine.

Do I need to do something special with declaring the connectivity for the DE command (in code) when trying to use a run-time database?

Any advice or examples would be greatly appreciated...sorry for the lengthy (maybe confusing) description of the problem.