How to change table access to view only?

[ncsthbell]

I have a form that has buttons on it to access tables. I want to be able to set it so certain tables can be viewed only when they click the button and NOT edited. I cannot seem to find the method I need to use to do this.

[Rabbit]

The third parameter of the OpenTable method lets you choose how to open the table.

[missinglinq]

The fact of the matter is, except in the early stages of development, tables should never be used for editing/entering data! Forms should always be used for this purpose! And even using tables for viewing records, if there are more than a handful, is adding an undue burden on the end users, as data in a table has no order! The forms don't have to be fancy; they can be run up in a few minutes using the Forms Wizard if necessary.

Linq ;0)>

[NeoPa]

The only way I know to stop the operator looking at tables however they want, is in Tools / Startup... / Show database Window.
Clear that setting and everything should go via your forms.

[ncsthbell]

Sorry, I wasn't as clear as I should have been. I have a button on a 'table maintenance' form, when you click 'emp names' it opens a form 'TM_EMP', this form is designed for data entry and/or viewing. What I want to do is only allow viewing, not editing. So, is there anyway when this form is opened that I can chnage some setting or option that will only allow viewing, not editing. Or, do I just set the properties to each column on the form to 'locked'???

[missinglinq]

In the Form Load event put

Me.AllowEdits = False

Linq ;0)>

[NeoPa]

In the design of the form, open up the properties and set "Allow Edits" to No.
If you ever need to have "Allow Edits" set to Yes then Linq's code is worth using. If it's ALWAYS no then it's probably better to set it in the design of the form itself (although Linq's code will work in all circumstances).