MSQuery don't show columns

C

CLR

Hi All.....

I'm trying to do a Query from Excel into an Access database to extract some
data. Normally, the dialog box shows the table names in the left window with
a plus sign and when you click on one, the plus sign changes to a minus sign
and it drops down to show the columns therein...........this one changes the
sign ok, but does not drop down to show any columns...........this procedure
works fine on another database, any idea what might be wrong here?.......

TIA
Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Ok, I got it........for those interested, it was a :security
thing".......once all security was stripped out of the database, the Query
form Excel worked fine.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top