Can you lock individual cells, like in excel, with MS Access?

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

Guest

I am trying to keep users from editing one particular column in my database.
Is this possible with access? I have used this feature in excel all the way
down to individual cells but have not found this to be an option with 2003
Acces. Thank you.
 
Assuming you are preventing your users from editnig tables directly (as you
should be), you can set the enabled property of the cnotrol on the form to
'No'

If you are letting your users see the tables, then no...you cannot lock down
that field.

See number 11 at the bottom of the page:
http://www.3nf-inc.com/Access10.htm
 
You must log in or register to reply here.

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

Help With MS Access 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Locking Out 2
Alternative for MS Excel VLOOKUP function in MS Access2003 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Locking cells 3
All Access Database locked instead of locking only one? 1

Back
Top