It's basically two tables, one with inventory, tools are the primary key, then various identifiers of the tools follow serial numbers, manufacturers etc, the final field is the employee field, which relates to contact information of that employee. I can have many people check out many tools, what i don't have is the ability to see who checked out the tool prior to the current borrower.

Thanks again!...

I have an inventory list, and a list of employees, an employee writes his name next to the tool he checks out, when he is done someone else puts their name in the field. Is there a way to look and see any and all who have ever checked out a given tool, while only displaying the current employee? This is Access 2003.

I could try the VBA steps needed, we are not all going to be using this from the same domain, we have users on-site that will be remote connecting, and accessing a shared drive where the database is located. Security is not terribly important. I just don't want people messing with existing data, they have no real incentive to. I would only need one user, as all on-site people could use the same one.

It is a simple inventory list, I just don't want data getting erased on accident. I want to spend very little time, again just the three fields need updates the others need to be locked to prevent them being accidentally erased or modified. Thanks again.

I am running Access 03, and have two tables, I would like three columns in one table to be edited by some employees, and full permission of editing fields by others. Can this be accomplished through the security settings? Ideally two separate passwords would be used, one for admin, and one for regular employees, similar to a Windows login, then based on the password given, have three columns be capable of updates, or all columns be capable of updates....