passwords and switchboard

[bquan]

Hello All,
I have a switchboard that comes up at start up and limits access to my tables and tool bars and menus. When I set up the administrator password and log on to the database the switchboard opens up with all the limitations.
I want to have complete access to all menus and tool bars (I know I can open the database window by pressing F11, but have not access to any of the menus).
Can you please help me.
I want my users (some) to be able to have the switchboard come up when they log on and only have access to forms for data entry and reports to print them.
I want myself and other administrators to have the database window open as soon as we log on with access to everything.

Now, since I don't have access to the tools menu and the user and group account window I can't change the settings so that I have complete access. Please HELP!!

 

[Autoeng]

When you enter your logon pass word hold down the shift key as you press enter. That will disable all of your startup options. Once you do that save the file after turning your startup options back on (enable full menus, ect.). This will be your working backup. Then turn off all of the options and save this to another location. This will be what you distribute. Why do this. I've had it happen that even after pressing shift while enter that the menu wan't available and I couldn't get it back.

Autoeng

 

[bquan]

Thank you so much. This did work. I can now get into my full menus. I have another question though. If I save one file with the full menus at start up as my working copy for administrators, and another with all the start up limitations (that I will distribute), then when they do data entry they will be completely different (well, one updated and one not) and vise versa.
How can I avoid this? is there anyway to have both in one? For administrators just to open it to full menus and for users or data entry people just to limited access?
Please let me know if there is a way to do this (or at least if I have two copies of the database, how do I update both of them regularly back and forth?)
Thank you so much. This was great!!!

 

[ghudson]

Changing the startup options will not take effect until the next time the db is opened. Using true Access security will allow you do to what you want based on the CurrentUser funtion.

The code below will allow you to enable/disable all toolbars. You can set this up to run based on the user ID (however you define those) logged into the db.

The below code will disable (hide) all menu bars and tool bars. Ensure that you have a way to enable (unhide) the menu bars and tool bars (transparent command button) before you hide them!

'this will disable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

'this will enable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

An added bonus is the right click option is disabled if the menu bars are disabled with this code.

HTH

 

[Autoeng]

Split the database into a front end and back end. Make a copy of your front end and change the name to something different from the other. Set the startup options on the 2 front ends one for users and one for admins. Link both front ends to the same backend. Create a two batch files (one for users and one for admins) to copy the front ends (each batch file will refer to the appropriate front end) from your server to each users machine. Then enter the command to start the database (again with the appropriate front end names. Distribute the batch file. This way when someone executes the batch file they always get the appropriate front end in the latest revision level. Below is a sample of my batch file.

md "c:\my documents" (I do this because some machines are Win NT and some are Win 2000, if c:\my documents exists it does nothing)
copy s:\everyone\ecndatabase\BereaECN.mdb "c:\my documents\*.*" (this copies my database front end from the server to the users my documents folder)
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\my documents\BereaECN.mdb" /WRKGRP "s:\everyone\ecndatabase\Secured.mdw" (this starts access, loads the database with the correct security workgroup)

I've often wondered if there was a way to code the database to look at a users name then compare to security level then open the database with menus open but haven't figured it out yet. Perhaps someone will suggest an alternate method.

Autoeng

 

[Autoeng]

I knew there had to be a way to code it! Thanks ghudson. Alot simpler than my idea.

Autoeng