On 27 mei, 18:16, "Jeff Boyce" wrote:
How is it that the user can "see"/get to the table?

I am not sure what you mean. But he can just go to the tables,
reports, queries etc by just minimizing the active form.


How does the user know which table to add the record to?

It's more like that I don't want the unauthorized user to add records
to certain tables. Only an administrator should be able to add
records. For example: a combobox contains a predefined list of
Officers. I don't want each user to add new records for the same
person eg. J. White, Jimmy White, J White.

One approach might be to hide the database window and only present forms to
the user.

Via Tools, Startup? But that can easily be changed by the user right?

Another might be to "hide" the tables.
How do I do that? in VBA? Could you please explain in more detail?