Different switchboards for different users?

[Chris Burnette]

Question: Is there a way to define a different default switchboard depending
on which user is logged in? Our company has multiple departments, and we
want each department to have their own menu available at startup. Does
anyone know of a way to do this?

Any input is appreciated.

Thanks,

Chris

 

[Jim Thomlinson]

The best way I know to do this is to have multiple fron ends all connecting
to the same back end. All of the tables sit in the back end but none of the
reports, forms or queries (unless they are common to all users then you might
want them in the back end). The queries, forms and reports are created in
seperate databases that are linked to the tables in the back end database.
You can create as many fornt ends as you want. This gives you control over
who has access to what. This is kind of high level but it might get you
started...

 

[Chris Burnette]

Thanks for the response Jim.

I was actually thinking of this, the only issue is that if a user were to
get a copy of an MDE front-end from another department, that would (I think)
allow them to view that department's switchboard, rather than their own. I
haven't really figured out a good way of securing the MDE front-ends, as
they're files, and hence can be copied.

Still, it seems like a pretty good solution, as I don't think many of the
employees here would bother copying another user's MDE just to see more of
the database.

On a side note, does anyone know how to open a query from the switchboard
and have the results displayed on a form? I figured out how to have a button
on the switchboard open a query, but it always opens it in datasheet view,
which I don't want the users to have access to lest they copy the data.

Thanks,

Chris

 

[Rick B]

If someone got an MDE from another department, then yes, they could see that
switchboard, but they would still only have access to the objects that your
security dictates. If you have implemented user-level security and given
them appropriate access, then being able to see an item on a switchboard
would be irrelevant.

 

[Rick B]

Your form/query question (which you have now posted about five times) has
been answered in one of your many posts.

FYI - it is considerer rude to post the same question all over the place
like this. If someone takes the time and effort to answer it in newsgroup A
and then finds that it was also posted to newsgroup B and answered there by
someone else, then that first person feels as though they spent their time
and effort for nothing.

If you do not know which newsgroup in which a message should be posted, then
enter multiple newsgroups in the "Newsgroups:" field when you post. This
will place a COPY of the message in each group. If someone posts a reply,
that reply will be visible in all the newsgroups to which you posted. Once
an answer is posted, people will know they do not need to add to your post.

 

[Joan Wild]

FYI - it is considerer rude to post the same question all over the
place like this. If someone takes the time and effort to answer it
in newsgroup A and then finds that it was also posted to newsgroup B
and answered there by someone else, then that first person feels as
though they spent their time and effort for nothing.

Or worse, they provide an answer not seen in one of the other forums, and
other readers lose the benefit.

 

[Chris Burnette]

Rick, thank you for your response, I was not aware of that.

-Chris