SharePoint User Group UK

Good morning

We are using Infopath forms in SharePoint 2007 in our business processes but we have a problem with the forms getting locked by users. Does anyone know if there is a way of finding out which user has locked the form? (in SPD we can see a padlock against the form) error message just says it is in use by another users but no idea which one.

Any advise would be really appreciated.

Brenden

Brenden,

Are you looking for a code solution, If so, accessing the underlying SPFile.CheckedOutBy property will return an SPUser that has the file in either  a Short or Long term lock.

Infopath (and any other office app) would take a short term lock (I.e. for the life that the application is open) if a user opens a form for editing, but I don't think that shows up on the Checked out to column of a document library as I'm pretty certain that is long term checkouts only.

If it worth turning on the force check out for editing option of the library? This would ensure that the user name is displayed in the Checked out column?

Paul.

I'm looking for a quick way to find out who has the file open, maybe a SQL query the could be run to find out who has the form open.

Thanks

Brenden