I use MS Access and Sharepoint web services to read and process Excel workbooks in a SP (2007) document library. How can I tell (without trying to open) if a document is already open by another user. Right now, I open the workbook, then test for readonly. I'd rather be able to know before I try to open it.Jim

Can you require Check In/Out, then you can check to see if it is or isn't, then react ??Steve Clark, MCTS | Twin-Soft.com Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of them there forum buttons that artificially inflates my narcissitic ego... I mean gives me points.

Steve, that would probably work, but my users might screw it up and never check the workbooks back in, meaning I'd get phone calls at 3 o'clock in the morning (I'm in Beijing, my client is in Virginia....) But it would likely work. Anyone have any other ideas? I know if I try to modify the properties on the web interface, it won't let me, because the workbook is open, so it must know without opening the workbook....Jim

You could designate someone locally to be an admin, who would have the ability to override a checkout. [The irony that I'm in VA, but I don't want to be that admin.]Steve Clark, MCTS | Twin-Soft.com Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of them there forum buttons that artificially inflates my narcissitic ego... I mean gives me points.