How to prevent users from looking into the database?

[Niebotel]

I have created a access 2007 application (frontend and backend). I distribute the accde with runtime. But I want users to prevent that they look into the database using full access. With current database options I can hide things, but users can set it back. What is the solution?
Encrypting does not work I think, because I have to give the users the password I suppose.

 

[TheAceMan1]

How are ya Niebotel . . .

You can hide/show the DB window.

To hide:

[blue]   Docmd.SelectObject acTable, , True
   Docmd.RunCommand acCmdWindowHide[/blue]

To show:

[blue]   Docmd.SelectObject acTable, , True[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Niebotel]

I'm fine thanks!
I finally completed my application (I think 50 hours of programming and testing)

Before distributing it (planning 1 january) I want to solve this issue.

I tried your suggestion but nothing happens.
I have putted the coding behind my opening screen on the on open event. The only thing I see that the screen is not maximised anymore, but, the DB windwow and the office button are still available.

Still hoping to find a solution fot this last issue before implementation.

Greeting Willem

 

[Niebotel]

I now succeeded to hide the DB window, but it is still possible to reset things by using the Office button. In the backend the office button has only two itens (Close and develop) but in the frontend all the options are availeble. How I managed that I do not know, but I would like to have that also for the frontend.

 

[Niebotel]

Problem solved; Thanks for the help!!

 

[CWestII]

How was it solved?