MSQuery won't show columns
 

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

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

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

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