Locking users in a form..

[acarruth]

Hi,

Is there a way to lock users in a form, such that they can't view the table from which the form draws data? I understand saving it as an .mde will hide the source code, but I also want to hide parts of the table..

Any help would be greatly appreciated.

Cheers,
Allan

 

[drctx]

you can hide the database window by going to tools, startup, and put a check in "display database window". then to bring it back they would have to goto windows, unhide or by undoing what you did to hide it.

 

[acarruth]

is there a way to ensure that they couldn't bring it back unless they were an administrator though? Like a secure way? I need certain fields to be hidden to some users, so having no read access on the tables would do this.. but having no read access on the table makes it such that the user can't read the form that utilizes that table.. hmm

thanks for the help.. any more would be appreciated.

cheers,
allan

 

[drctx]

or you could add
form.modal = true to the form_open and then they can't do anything outside the form until it is closed.