LOCK TABLE in Access db

[MsLady]

I'd like a code to lock a table in my access database so that it can not be mistakingly deleted by the user.
It's a very basic database program i am using for basic reporting purpose. I'd like to lock the master table from the user. How can i achieve this? Any ideas?

 

[RuralGuy]

Hi M'Lady,
I take it this db has not been secured and you have made no attempt to force the user to use *only* your forms to run the db?

 

[The_Doc_Man]

There are two ways to do this.

1. If the user does not have access to the tables pane or the DB window, you simply don't put that function on the switchboard or other controlling layer.

2. If the user potentially has access to the DB window, you MUST secure the database. While many methods exist, the best method overall is to use workgroup security. You can search this forum for the topics of Workgroups and Workgroup Security and Securing a Database.

Third party tools and some clever home-grown tools have been posted from time to time on this and other forums, but the bottom line is this: Access Workgroup Security is DESIGNED to provide this kind of protection and is already built in to Access. It is the tool that Microsoft will suggest that you use. (Which is not necessarily grounds for wildly jubilant praise...)

There is a school of thought that says, "Use the tool designed for the job." Since I am of that school, I suggest you look into workgroup security. Access Help should also have some nice articles on the topic.

 

[MsLady]

Thanks Doc_man, you absolutely rock.
I was just looking for a quick and easy way like something btw: hiding the db window and workgroup security.
I thought i could get away with the hassle and complication of implementing the workgroup security.

On the topic of workgroup security: I have implemented this in my db a few times now but i have to find my way around it each time. Is it me or does it seem a little complicated? Is there a clear and straightforward/step by step manual for this? [Hey i know it's pretty self explanatory but i always struggle through it each time...oh well]