DoCmd.OpenTable

J

Jim Pockmire

How can I use this command and prevent users from adding or deleting
records - only allow editing records?
 
F

fredg

How can I use this command and prevent users from adding or deleting
records - only allow editing records?
Click to expand...

DoCmd.OpenTable "TableName",acViewNormal,acEdit

You are, however, making a big mistake by allowing users to enter/edit
data directly into a table. Tables have no useable events and are
susceptible to data entry errors.

You should hide your tables and make the users use a form for all
entry/edits. No reason not to. If you wish the appearance of a table,
simply open the form in Datasheet view.
 
J

Jim Pockmire

Opening the table "acEdit" simply opens the table for editing but I am able
to add records to the table. I believe I need to open a form in datasheet
view and set one of the properties to edit only (your last suggestion).
 
Top