Hello all I need your help. I have an Access ADP database that has a form that is accessing SQL Backend. When I update a field on the form there is a trigger on the SQL table that does a update to that same record. This is then cauding a lock on the access record. Is there a way in the trigger to release any locks on that record? Thanks
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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TRIGGER CAUSING LOCK PLEASE HELP
- Thread starter SeanB
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question