Link to home
Start Free TrialLog in
Avatar of mike2401
mike2401Flag for United States of America

asked on

Shared files w/ file locking, maybe OWA public folders?

Our lan admin just showed off OWA public folders as a means for field users to view & edit a collection of excel files.

The only problem is that if I open one of the files for edit, then another user opens the same file, he won't be notified that I'm working on it till he tries to save changes, and then there's a big mess trying to merge two sets of edits.

A work-a-round I came up with is to create a sub-folder called "These Files Being Edited".  Then, if I want to edit a file, I MOVE the file into that sub-folder, THEN open it.

Of course, people would need to potentially first look in the parent folder, then look in the sub-folder if the file is not there.

Essentially, we need some way for field users to map a drive to a share on our file server.
We don't do VPN because we don't have fancy access control rules, and the vpn laptop would be on our internal network - a scary security threat.  

This morning, I saw this network attached storage device whereby the users run a client setup.exe, and are then able to access shared data on the hard drive.

It seems silly to buy an external hard drive when we have a pix, iis, isa, exchange 2007, and file servers running in our vmware infrastructure.

Maybe there's some cloud drive which might solve our problem better?  (like Amazon or google docs?)  (But, it seems like a bad idea to rely on 3rd party for storing data, when we have a fairly fancy network.

So, any solutions to this problem?

All ideas very much welcome and appreciated.

Avatar of Leon Fester
Leon Fester
Flag of South Africa image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mike2401


Thanks.  I do have the sense that sharepoint is the right solution, but we are not in a position to deploy that right now.

In fact, if OWA public folders imply notified the user that he is attempting to edit a file already being edited, I'd be happy as a clam.

It just seems soo dumb that it only tells you at the end, after you're done editing, and have created a collision.


PS: the more I think  about it, it doesn't make sense for me to suggest a 3rd party cloud solution because ultimately, it could lead to them out-sourcing our entire operation.  A small designated external hard drive reachable by field folks for the limited purpose of collaborating on a set of documents is probably fine, however.
The problem is Public Folders does not care about who has files open since it is not designed as a repository system.

"A small designated external hard drive reachable by field folks " creates even more headaches.
Since the data will be accessibile from public locations, somebody could steal your data or at least try.
You're also not solve the issue of users being notified that a file is open before they open the file themselves.

There is nothing wrong with outsourcing and cloud computing, especially since you'll have support and SLA's to maintain your systems and availability. OH SNAP! you're probably the Vendor looking after the site.

At the end of the day, you still want to offer the best solution available.
And if somebody else should mention a simple solution, like cloud computing then it will make you look like you don't know what new technology is available out there.

If you want a check-in / check-out system then consider something free like Subversion/SVN.
It can be published onto the WWW with security, tracking and all the other nice to have's.
Thanks for the response. I'll take a look at subversion/svn.

BTW, my assumption, and perhaps it's just that, is that a small designated drive (NAS) would behave as does our mapped drive on our lan:   when I double click an excel file, and then another user double clicks on the same file, the 2nd user gets notified and can open the file as read only.

I'm not sure how that works: perhaps it opens a ~temp file when the file is opened, and then the other user's excel sees that???

I wouldn't personally advise such a solution.
If you're only sharing Excel spreadsheets then have a look at "shared workbooks"

Not sure how it will behave with the public folders but I've used it successfully on many LAN/office setups.
Thanks dvt_localboy.

I think we ultimately will indeed need to go with sharepoint.

Your other suggestions were indeed interesting and I might use if for some personal stuff.