Occasional Locking problem on sql tables linked from access with o P. Scaram 21.09.2006 21:31:02 I use a form linked to an sql view of a master detail relationship. The form is snapshot and uses access form filter to locate records. When the records are retrieved we go to another form with a master detail design where we can update the record. That is where we get an ODBC error indicating that the record is locked. I used your advice on timestamp and non null boolean fields and things have improved on the locking. However it still happens sometime. Usually after repetitive searches the system slows down and in the end at an update it returns an ODBC locking error. I once caught the locking on the sql manager. There are lots of PAG locks all the same on the detail table and this seems to lock the other spids. I wanted to ask you is there a way to improve the problem by changing the options refresh intervals and odbc refresh intervals or this is unrelated OR Is there a way to improve the design of such a master detail situation, which is quite common. Also How is the locking affected by the speed of the client and the activity on the server. Would faster PCs and Server help. If I added indexes on the common fields of searching would that improve the search. Is there a good reference for this kind of problems. My client wants a solution and because the problem is transient I do not know how to go about it. Also it only happens with the master detail form , we have single table forms and they never lock. Thank you in advance. P. Scaram