Protecting columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple DB with only 69 records. I need to restrict users from
editing the 1st two columns. Also I need to prevent the user from deleting or
appending records.

Thank
BC
 
BC,

On your Form, set the Locked property to Yes for the controls bound to
the fields you want to protect, and probably set their Enabled property
to No. And set the AllowAdditions and AllowDeletions properties of the
form itself to No.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I protect columns Access 2002? 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
restrict fields or columns 1
Excel Comparing two columns 1
Prevent the user from adding a new record while still allowing him tomodify existing records 2
Form displays #DELETE before closing 2
Password on Command Button? 1
Can a Check Box Prevent Other Fields from Being Used? 1

Back
Top