"Keith W" wrote:

> "Beatrix" <Beat***@discussions.microsoft.com> wrote in message
> news:ED41A746-C421-4B79-8AEE-573ECE71EC23@microsoft.com...
> > Hi!
> >
> > I have a database of which I want to use as follows:
> > I want the user to login, just with the name, no password required, and
> > according to the name the database will look differently.
> > In fact this is for my boss, I want him to see some reports only, and me
> > as
> > an admin, see everything.
>
> Yes you can do that.  Set the startup options such that the database window
> and built-in menus are hidden (you will need custom menus for your users).
> You would also need to disable the "show database window" shortcut key (F11
> IIRC).
>
> > Hiding tables is not a good solution.
> >
>
> Hiding *just* the tables perhaps but hiding the database window is
> essential.  You would need to create a form for your boss to run the reports
> from.  You would open the form from the startup options.
>
> HTH - Keith.
> www.keithwilby.com
>
>
>

"Keith W" wrote:

> "Beatrix" <Beat***@discussions.microsoft.com> wrote in message
> news:ED41A746-C421-4B79-8AEE-573ECE71EC23@microsoft.com...
> > Hi!
> >
> > I have a database of which I want to use as follows:
> > I want the user to login, just with the name, no password required, and
> > according to the name the database will look differently.
> > In fact this is for my boss, I want him to see some reports only, and me
> > as
> > an admin, see everything.
>
> Yes you can do that.  Set the startup options such that the database window
> and built-in menus are hidden (you will need custom menus for your users).
> You would also need to disable the "show database window" shortcut key (F11
> IIRC).
>
> > Hiding tables is not a good solution.
> >
>
> Hiding *just* the tables perhaps but hiding the database window is
> essential.  You would need to create a form for your boss to run the reports
> from.  You would open the form from the startup options.
>
> HTH - Keith.
> www.keithwilby.com
>
>
>

> Dear Keith!
>
> I wanted to avoid it, but by hiding the database I locked myself out.
> Would you pease tell me how could I get in to my work again? :)
>
> Beatrix
>
> "Keith W" wrote:
>
>> "Beatrix" <Beat***@discussions.microsoft.com> wrote in message
>> news:ED41A746-C421-4B79-8AEE-573ECE71EC23@microsoft.com...
>>> Hi!
>>>
>>> I have a database of which I want to use as follows:
>>> I want the user to login, just with the name, no password required,
>>> and according to the name the database will look differently.
>>> In fact this is for my boss, I want him to see some reports only,
>>> and me as
>>> an admin, see everything.
>>
>> Yes you can do that.  Set the startup options such that the database
>> window and built-in menus are hidden (you will need custom menus for
>> your users). You would also need to disable the "show database
>> window" shortcut key (F11 IIRC).
>>
>>> Hiding tables is not a good solution.
>>>
>>
>> Hiding *just* the tables perhaps but hiding the database window is
>> essential.  You would need to create a form for your boss to run the
>> reports from.  You would open the form from the startup options.
>>
>> HTH - Keith.
>> www.keithwilby.com