Hiding main database screen

[Guest]

I have designed a database using switchboards to access the data entry and to
run reports. How do I make sure they don't have access to the actual tables,
etc. Maximizing the switchboard form, etc. works, but the user will most
likely have the data-entry form up at all times, along with several other
programs they are running, so will probably minimize it at times. When they
do that, the main database screen becomes visible.

Patti

 

[Guest]

In th "OnOpen" event of your Switchboard/MainMenu place the following code:

Private Sub Form_Open(Cancel As Integer)

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

End Sub

HTH,
Al

 

[Graham Mandeno]

Hi Patti

The short answer is to go to Tools>Startup... and uncheck the following
options:
Display Database Window
Allow Full Menus
Use Access Special Keys

However, this will keep out only the most benign and uncurious of users.

To lock it down better, you should consider using user-level security.

 

[Pieter Wijnen]

Better to provide them with a mde/runtime....

Pieter

Hi Patti

The short answer is to go to Tools>Startup... and uncheck the following
options:
Display Database Window
Allow Full Menus
Use Access Special Keys

However, this will keep out only the most benign and uncurious of users.

To lock it down better, you should consider using user-level security.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have designed a database using switchboards to access the data entry and
to
run reports. How do I make sure they don't have access to the actual
tables,
etc. Maximizing the switchboard form, etc. works, but the user will most
likely have the data-entry form up at all times, along with several other
programs they are running, so will probably minimize it at times. When
they
do that, the main database screen becomes visible.

Patti

 

[Guest]

Thanks, Al!

--
Patti

In th "OnOpen" event of your Switchboard/MainMenu place the following code:

Private Sub Form_Open(Cancel As Integer)

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

End Sub

HTH,
Al