Excel - Get Extenal Data question

C

Correy

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
 

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

Similar Threads

Password protect data entry 1
How to Create a Macro to Import External Data 0
Split data in field on character return 0
Query Question 2
Can't create a report from my query in Access 1
External data link to Access - no linked tables? 3
Access MS Access vba AfterUpdate coding question (hopefully a simple fix!) 0
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0

Top