Question Switchboards

[Tinarosa]

Hi Simon

I have created a menu for my base on a form. This works well. What I need is on opening this form I do not want the operator to be able to access the working behind it. In other words I need to hide all of Access' menues and other items which will allow someone to get into the program and start changing things.

I have closed all the menus but still am left with one bar at the top.

The menu (form) is opened from a shortcut on the desktop. on exiting the menu you are returned to the desktop.

 

[Simon_MT]

It depends what you mean by workings of Access.

One level is to make a mde accde version which stops users changing forms, reports, macros and modules.

Another is to link the tables so these too can't be maintained.

All that leaves is Queries!

To take out the dropdown Menus I've not really tried, others can help about suppressing these facilities but they have been removed in Access 2007.

Simon

 

[Tinarosa]

Thanks Simon

 

[Simon_MT]

A couple more things, in Options there is Display Form and I put the First Menu in there. I know Access 97 had Hide Database Window but is was retreivable.

Simon

 

[Rabbie]

A couple more things, in Options there is Display Form and I put the First Menu in there. I know Access 97 had Hide Database Window but is was retreivable.

Simon

Most users do not want to know about the internal workings of Access and would much rather have a nice form based interface so it is often sufficient to hide the Database window. Then if they have nice forms where they can select what they want/need to do they are very happy.

To successfully lock out the knowledgable hacker among your users is much harder and if you have one of those among your users you need to make sure they behave themselves.

 

[Tinarosa]

Most users do not want to know about the internal workings of Access and would much rather have a nice form based interface so it is often sufficient to hide the Database window. Then if they have nice forms where they can select what they want/need to do they are very happy.

To successfully lock out the knowledgable hacker among your users is much harder and if you have one of those among your users you need to make sure they behave themselves.

This is exactly what I want to do. Question? How?
I am not worried about the knowledgable hacker My user is just a plain user. How do I go about hiding the Database window?

 

[Tinarosa]

This is exactly what I want to do. Question? How?
I am not worried about the knowledgable hacker My user is just a plain user. How do I go about hiding the Database window?

Is it possible to compile my completed data base into a stand-alone .exe file? If so, is there a compiler available?

 

[boblarson]

Is it possible to compile my completed data base into a stand-alone .exe file? If so, is there a compiler available?

No, you can't create a standalone exe file. You can use the developers extensions to create a runtime package which will let your users install the database along with the runtime version of Access, if they don't have Access. You had to purchase this for versions previous to 2007. If you have Access 2007 you can download the runtime and the developers kit for free.

 

[Tinarosa]

No, you can't create a standalone exe file. You can use the developers extensions to create a runtime package which will let your users install the database along with the runtime version of Access, if they don't have Access. You had to purchase this for versions previous to 2007. If you have Access 2007 you can download the runtime and the developers kit for free.

Thakyou

Regards Tiny