Disabling "Click to Add"

[tgall]

Direct Route: How do I disable "Click to Add" in the tables?

Scenic Route: I built a database application that has several tables I call "dropdown tables". Their contents
provide the selections for many fields. I also built a Menu form with a block of buttons allowing the users to
view the "dropdown tables". Via VBA, the tables are acReadOnly to prevent users from modifying the
selections. During EUT (end-user testing), wouldn't you know, one of my testers validated he could not
modify the existing data, but he had a ball clicking the Click to Add function. He couldn't enter data, but
he added a lot of junk fields to the table.

I would like to add code to the VBA preventing Click to Add when an end-user is viewing the table. I want
the feature available when the Database Administrator needs to add a field.

[ssanfu]

Users should NEVER (IMO) be allowed access to tables. Data-entry is/should be through forms.

If I understand correctly, try:

Go to FILE/OPTIONS/Current Database.
Uncheck the option "Enable design changes for tables in Datasheet View"


I also always uncheck "Enable Layout View" and select "Overlapping windows".

I want the feature available when the Database Administrator needs to add a field.

I would suggest that a field should be added to a table in design view, not clicking on the "add field" column in a table.

[tgall]

Steve, love it when the solution is simple (ie, not 300 lines of code). Many thanks!