How to prevent (lock) the deletion of a column in a subform in Datasheet view?

[clebergyn]

Hello friends. I have a problem. Does anyone know how to prevent (block) deleting a column in a subform in Datasheet view?



A user accidentally deleted a column from a subform in "data sheet" mode. What to do to prevent?

I hope and, thank you in advance

[Bob Fitz]

You could create a "accde" version which would prevent uses deleting the column

[NTC]

one of the features of the datasheet view is to allow users to do their own thing to a degree

you can build a continuous form instead - and as BF noted also consider the ACCDE deployment

[Micron]

I would say it's not possible to delete a subform datasheet field/column without going into design view and deleting it. If that's what happened, then either a regular user was fooling around behind the scenes or an authorized developer deleted the control for the field. An accde should prevent the former, but not the latter since that person would have permissions to develop the base file.

You can hide a column in datasheet view though, but that's not deleting. If that's what happened, an accde won't prevent it.

[Bob Fitz]

Before I made my previous post l tried to delete a column from datasheet view and it was deleted. When I viewed in design view the control was no longer there but this deletion was not possible with the accde file.

[Bulzie]

I just tried and in view(not design) hitting delete button with a subform column highlighted did nothing(no delete). Cleb you do mean the column is gone or just the data in the column? Is the column still in the table, just not the subform?

[CJ_London]

Using 2010, if the form is viewed as datasheet in a .accdb, you can highlight and delete the column (or right click and select delete), and as Bob says, go to design view and the control is no longer displayed. However, if you do not then save the form, the column is 'undeleted'. Perhaps this is a feature that became available in 2010 and was not available in 2007?

Personally I only provide users with a .accde so they can't mess with the forms, end of.

[Micron]

Well, you learn something new every day
I couldn't do it in 2007 and just assumed Microdaft wouldn't ever provide such a dangerous capability. Imagine that - now we have design control while in form view.

[CJ_London]

In 2010, in a datasheet view, if you right click on a column you get this shortcut menu - So not only can you delete a column, you can also add one that is missing - or add an existing one again.


It is a behaviour I have noticed in the past, but didn't pay much attention because I do a lot of work with runtime which does not use the default shortcut menus - so I add my own in so users never actually see the default one.

[clebergyn]

Friends, I figured out how not to let go. We have to go in the "options" menu, and disable the "enable layout mode" and also disable the "enable design changes ..."


Thank you all and good studies.