I was wondering if anyone had any ideas on how to setup a system of logging into a db, the user creates a new record and is the only who can make any changes to it in the future. I know this will probably be a lengthy process, but any suggestions are appreciated. Thanks for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
user adds new record, only one who can make future changes
- Thread starter breaker11
- Start date
I don't know if Access security will handle this or not. But you could get the user's OS login (do a search here, I have seen it recently) and store that as a field in the record. Then when you get the record, you would have to check the user again and allow edits based on that.
Might work... Terry M. Hoey
Might work... Terry M. Hoey
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question