Access Lock Fields in Table Design View

Is there way to lock fields in table design view so that the entered values cannot be changed.

Thanks.
tahirihAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
No.
Lock the form controls bound to the field.
0
neil_squiresCommented:
It sounds like you are trying to duplicate functionality similar to an Excel where you can lock the fields and view them in a grid fashion.  Unfortunately, while an access table may look like an excel sheet, it behaves differently.

Best practices are to use a form to view/update the data in an Access database.  You can lock the fields a couple of different ways.  The simplest is to make the fields locked or disabled.  If you want the same look as Excel, you can also run a form in Data View rather than formview.  This will look similar to the table layout and is harder to work with than form view, but is doable.

HTH
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Is there way to lock fields in table design view so that the entered values cannot be changed.>>
  You'd have to user user level security to secure the table design.  However ULS is a bit complex and you should understand it fully before trying to implement it.  Also be aware that the feature has been dropped starting with Access 2007.
 You can download the Access Security FAQ here:
http://support.microsoft.com/?id=207793
and Joan Wild keeps a good page on Access security:
http://www.jmwild.com/Accesssecurity.htm
JimD.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jeffrey CoachmanMIS LiasonCommented:
tahirih,

Or, depending on what the user should (or should not) be doing, you can simply open the form in "Read Only" mode:

  DoCmd.OpenForm "YourFormName", , , , acFormReadOnly

This will save you the trouble of figuring out which fields to Lock/Enable/Disable and when.

;-)

JeffCoachman
0
Rey Obrero (Capricorn1)Commented:
yeah you could do that if you want to lock *ALL* the fields/controls, but it guess that is not the case here.
0
tahirihAuthor Commented:
Sorry everyone for the delayed response, I am not getting e-mail notification that answers have been posted.

0
tahirihAuthor Commented:
Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.