Disable the ability to move columns in a query?

[dhaugland]

I have a database with a bunch of users and would like to NOT allow them to change the order of columns in the queries. Does anyone know how to accomplish this?

[Bob Fitz]

Present the data in a form. I would never allow users access to queries or tables.

[orange]

I agree with Bob. Take control --users interface with the application via FORMS-only!

[dhaugland]

Thanks to both of you. I created a sample form with this data, but I can still move columns around. How do I set it so that they cannot be moved?

[orange]

Please describe how user moves fields with the form.

Sounds like you may have to research ACCDE.

[Bob Fitz]

Thanks to both of you. I created a sample form with this data, but I can still move columns around. How do I set it so that they cannot be moved?

Sounds to me as though your form is in datasheet view. Try creating one as a continuous form

[June7]

Since there are multiple users, have you split the db? Does each user have their own copy of frontend installed on their computer? If all yes, why worry about moved columns? If not yes then why isn't it?