Can someone help on how to set a password to a Table in Access 2013.
Thank you
Novice
Windows 10 
Access 2010 64bit
Can someone help on how to set a password to a Table in Access 2013.
Thank you
Virtually Inert Person
Windows 10 Access 2016
AFAIK, you can't. You can set a password on a db though. However, there's not much use to that if the tables are not split into their own back end database, and anyone who knows a bit about Access can expose the password if they can get into the front end nav pane. If that doesn't help, maybe explain why you want to do this because there might be other options e.g. proper permissions on the db folder(s).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 10 Access 2010 64bit
Helo Micron
Thank you for the response.
I just want to protect the structure of the table design. I would not want users bumping into the structure of the table design
Any other option would be appreciated.
Vincent S
Virtually Inert Person
Windows 10 Access 2016
There's a lot you can/need to do but it's a broad subject and has been covered many times in many places before. Suggest you research how to secure an Access database; maybe start here
http://www.mendipdatasystems.co.uk/a...les/4594431956
Change User Password form -- it's writing the ***** mask to the table instead of the new password
Posting Permissions
Reply With Quote