Hey there,

I've been having basically the same problem that's been
driving me nuts for the last few days.  I just found this
info on another post that I believe is a solution.

"From the Tools menu, select Options and on the General
tab, check the box
for "Confirm conversions at Open".  When you then go to
attach the
datasource, you will be given a choice of which
connection method to use."

Try using this option, I think it will reveal the full
list of tables and queries for you.

Cheers,
Tony