Direct Table Access

[TastyWheat]

I have a database that's almost finished. I've built a few forms for the major parts of the database, but some other data is only changable through the tables directly. The remaining tables (without corresponding forms) are pretty small and shouldn't require changing that often.

Assuming I put user-level restrictions on the database, would it be okay to allow certain users to directly add/edit/remove entries to these tables?

My instincts tell me I should make a simple form for each table, but I'm looking for the path of least effort.

 

[KeithG]

I would personally never let the user modify data directly from the table. I would at least create a form with the wizard.

 

[TastyWheat]

I thought someone would say that. It doesn't feel right to give direct access and it won't kill me to make a few more forms.

 

[Moniker]

If they're just lookup forms like 1=This, 2=That, and so on, you can just use a form to display the table in datasheet view, which takes about two minutes per form.