Hello,

I was wondering when using the "Get External Data" feature in Excel from an
Access Database.....is there a way to only allow certain tables/fields to be
selected?

What I'm finding is when setting up a new or editing an existing query using
the Get external data feature it shows all the tables/fields.

I would like to setup a query where the users can't get access to the data
in the other tables/fields I don't want them to.

Any suggestions would be greatly appreciated.
Thanks, Correy

hi there how can i downl, datebase sofwear

"Correy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I was wondering when using the "Get External Data" feature in Excel from
> an Access Database.....is there a way to only allow certain tables/fields
> to be selected?
>
> What I'm finding is when setting up a new or editing an existing query
> using the Get external data feature it shows all the tables/fields.
>
> I would like to setup a query where the users can't get access to the data
> in the other tables/fields I don't want them to.
>
> Any suggestions would be greatly appreciated.
> Thanks, Correy
>