Keep users from going 'behind' the forms

[cwash]

How do you keep users from accessing the tables, queries and so forth.

I do not want users to be able to go to 'design view', or minimize or whatever to get to the the underlying tables.

Is creating a custome tool bar the only way to accomplish this? Or is there some other way?

I played around with the properties, but that didn't seem to do what I'm wanting.

TIA

 

[Fuga]

You can use the security options to set rights to users.

Tools - security -... (translation from swedish)

Fuga.

 

[iangirven]

In the form properties set it to pop up and modal then remove the control box with the minimise buttons and the shortcut menu.

this will stop anyone minimising the form or right clicking to get in the design view.

this also means the standard toolbars and menus are covered by the form to.

If you use this you will probably want some method of getting into the design view yourself for doing updates etc.

hope this helps

ian

 

[cwash]

I'm glad I made a copy of the db before I changed the properties!

I changed all of the properties you told me too, now I can't get to any of the forms.

What do I have to do to 'undo' the changes to get back to where I was?

Does each form have to be changed or just the switchboard?

You had also mentioned "If you use this you will probably want some method of getting into the design view yourself for
doing updates etc."

What method would I need to use if I need to get to the design view?

TIA

 

[DW]

Simply Open the db with the shift key held down.

When you're more experienced, you can disable the shift key to lock out unwanted users.
Also go to tools-startup. uncheck the boxes.
you can still get in via the shift key.
DW

[This message has been edited by DW (edited 05-30-2002).]

 

[iangirven]

If you want you can create a command button on the main menu that when clicked asks for a password.

create some VB code to check the password validity. you could set it as a string within the code itself or create a password and user id table.
if the password entered is correct you can then tell it to close all the open forms therefore gaining access to the design side.

unfortunately youll have to change the properties for each form.

if your not to experienced with vb just use the shift key when opening the database as DW said.

hope this helps

ian