set admin and user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Beatrix said:
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.
Click to expand...

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.
Click to expand...

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
 
Hold the shiftkey down while you open the database. That will bypass the
Tools, startup settings and any autoexec macro.
 
Back
Top