set admin and user

[Beatrix]

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.
Hiding tables is not a good solution.

Please help, thank you!

 

[Keith W]

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

 

[Beatrix]

OK, I see, F11.
Cool.

Now all I need is to build something that is impossible to do.

 

[Beatrix]

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

 

[Joan Wild]

Hold the shiftkey down while you open the database. That will bypass the
Tools, startup settings and any autoexec macro.