Hiding Access Query from Excel (1 Viewer)

Rainbowhawk · Mar 25, 2015

Is there a way to stop selected queries and tables from being available to excel as external data sources?

I am looking for a way to hide them from the list of available data sources to anyone who selects a particular database

Thoughts?

CJ_London · Mar 25, 2015

I don't believe so.

It is probably not something you would want to do, but you could put the 'allowed' tables in a separate database and then password protect all the others

Rainbowhawk · Mar 26, 2015

Hi

I have already hidden my tables by holding them in another db and linking to them, I now have half a dozen queries, with just one output query, however I don't want the end user to access the feed queries.

Trevor G · Apr 8, 2015

Why not use the final query to output to a separate database as a Make Table then they only have access to the one table.

Rainbowhawk · Apr 10, 2015

The db is written to their C drive as part of the process, however the admins need to be able to update this information on the fly.

I have added a version number to the data set that highlights if its older than the established version and prompts them to update.

They access the data through a query, however I wish to stop them viewing the background tables

Trevor G · Apr 10, 2015

As I have already suggested change the query to a make table and place the new table in a separate database and give them access to that one, they can't get to the other that way.

Hiding Access Query from Excel (1 Viewer)

Rainbowhawk

Registered User.

CJ_London

Super Moderator

Rainbowhawk

Registered User.

Trevor G

Registered User.

Rainbowhawk

Registered User.

Trevor G

Registered User.

Similar threads

Users who are viewing this thread