Form view only

[rgaetos]

Is there a way for users of an mdb to only view the form that opens up when the file is openned? I want to have it like an exe where users can only access item available to them on the main form. No design view, no object menu, just the form.

 

[yummy7]

hi rgaetos,
you are talking about users means that your DB is shared?
If you want an exe file. So there must be a Startup form means Sitchboard form, from which you can access other forms or Reports by clicking or any other way.Answer me.
We can make mde file.but before making it there are some rules to follow.

Are you getting my point?

 

[PHV]

menu Tools -> Startup ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yummy7]

Remember first save the copy of your mdb file before making any change.

 

[rgaetos]

My DB will be used by 3 or 4 people. There is a start up form where users can access other forms reports. When it comes down to it, the main thing I want is to hide the objects menu and do disable the design view.

 

[rgaetos]

thanks PH, got what I wanted.

 

[yummy7]

Ok I got it.
You want to hide Objects(Db design window--tables,reports,queries,formsetc)and VB code also.
So
1.Make sure you have Backup of your mdb file.

2.Compile your Data. For this go in the design view of any form, from menu bar View tab---view code----Debug tab---Compile Db.

3.Go tools---Startup----uncheck Display Db window,better to uncheck all.
And set in Startup option your Startup form.
feel free to ask any question.

 

[yummy7]

Forgot the folowing one
4. Tools---Db utilities---Make mde file .This file will be executable file of your Db.
This All procedure secures Db from users access in VBCode because they can access Db through menus from Menubar.