Access 2003 field protection

I am having an access table which have few fields. Some of my user had accidently deleted few fields in the table.

Is there any way to delete protect the table. But I want my users to read & write. Also I should have the access to delete the table without any issues.                                
LVL 3
samithsukumarAsked:
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.

therealmongooseCommented:
check out this link which explains access user level permissions and security:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp 
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
therealmongooseCommented:
In short you need to create a workgroup infromation file that is associated with your database - this defines the permissions that different users have over the database and can control wether a user is or is not able to delete a record...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As TRM said, the only way to control this is through User Level Security, but please be VERY careful if you go down this path. This is a complex and difficult subject to understand, and is not even available in Access 2007 if you think you might upgrade this to 2007 and use the new format at some point.

The link provided gives a good background, but Joan Wild's page (www.jmwild.com) is a great source for more info, and includes a step-by-step method for correctly securing your database. Merely running the Security Wizard is sure to cause more harm than good, and a thorough understanding of what ULS does (and what it cannot do) is important before you venture down this path.

Note, however, that you cannot specifically protect an individual column in a table. Access doesn't have that sort of granularity. You can move to a more powerful db engine, like SQL Server Express, which has a much more robust security architecture, and would allow you must greater latitude in how you control these things. SSE is free, easy to install and maintain, and integrates very nicely with Access.

Even in a secured Access database, users can still get to and delete tables unless you implement Run With Owner Permission (RWOP) queries for all data access. RWOP queries allow users to get at the data while also allowing the developer to remove all permissions from the tables (so the user, in effect, has no permissions on the tables and thus cannot delete that table, nor any portion). This, of course, increases the workload on you, the developer, but that's the tradeoff for security.

That said: A workgroup file doesn't contain ANY permissions ... all it does is contain Users, Groups, User+Group associations, and Passwords (encrypted, of course). The database you're securing contains all Permissions, and the Workgroup + Database entail the whole security package. Basically, a workgroup file does little more than authenticate the user, define the groups they are joined to, and provide the db with a SID that it can use when reading/writing permissions. The database then uses this SID to determine whether that user (or a Group that user belongs to) has sufficient permissions to perform the requested action.

0
Eric ShermanAccountant/DeveloperCommented:
Split the database into a front-end/back-end setup and park the back-end on your server.  Build a user interface in the front-end with forms that are bound to the specific tables.  There you can control what the user can or cannot do to the linked table using the form.  You can even create your own user and group tables thus bypassing the outdated built-in Acesss User Level Security.

ET
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.