how to hide linked tables in database window with VBA

[scren]

Hello,
I am new here and am glad to be a member of this group.
I spilited my DB and place the BE on a network.
For FE, I set diferent user group to pop up diferent form according to their using purposes. Now I want to hide the tables in the database window for one of user group, I'd do it by hand. Is there any way to hide them with VBA code?
Thanks.

 

[neileg]

Why not make the front end a mde so the users can't see the database window at all?

 

[Dennisk]

Users should not be looking at tables at all.
remember the maxim,
tables are for storing data
Forms are for Entering data.

You can hide the db window in the startup screen. Tools|Startup or it can be done in code

 

[scren]

Thanks.
I made it a MDE from my FE, users can only see the form. But I have a poweruser group that needs to run some queries on the DB. So I give them a way to see the DB window that shows Tables, queries, forms, etc. What I want to is to hide the tables, macros, Modules from the group or a way to show them Query oblect in the DB window.
Your comments and suggestion will be highly appraciated?

 

[neileg]

If they're going to build their own queries, I don't see how you can keep them from the tables.

 

[gemma-the-husky]

you can hide the dbs window with judicious use of a few properties

but as neil says - if you want to be able to design queries yourself this does not work. The problem is, is that Access is sort of half way between being a developers tools to develop integrated solutions, and a user's tool to interact with data - in which case the problems are exactly the same as you would get with shared excel files - ie any user can mess around with them

I tend to get around this by offering a "full" save as spreadsheet option, that provides a single (ie non-normalised) query including all the likely fields your users might want - I let them save this as an excel file, then they can filter sort and play with this etc to get what they want

 

[scren]

Thank you all. This is a great forum.

 

[jwhite]

scren: To get the users away from the DB Window, you might be able to utilize this concept with some modification: Universal Report Filter (QBF, URF)