Work on Same file simultaneously

[create_share]

Hi!

Is it possible for 2 or more users to work on a shared files simultaneously
and save it.

Or is there any utility that can do this job?

Thanks!

 

[Pegasus \(MVP\)]

Hi!

Is it possible for 2 or more users to work on a shared files
simultaneously
and save it.

Or is there any utility that can do this job?

Thanks!

What sort of file? Word? Excel? PowerPoint? Access? Other?

AFAIR, MS Access has a record-locking mode that allows several users to
update the same database at the same time. Best to repost the question in an
MS Access newsgroup if you're talking about Access, or in some other
product-specific newsgroup if you're thinking of a different product. If
this is a question about company files then your System Administrator is the
right person to ask.

 

[Patrick Keenan]

Hi!

Is it possible for 2 or more users to work on a shared files
simultaneously
and save it.

Or is there any utility that can do this job?

Thanks!

The answer is "maybe", and "it depends". Context is rather important.

You'd need to provide more information as to what the application is you're
hoping to use.

However, the short answer is that most apps just cannot do this, and it's
typically database apps that can to any degree. There, record locking
rules usually apply so that two users have rights to open the same
*database* at once, but while they can both edit different *records* at the
same time, they can't both have edit rights to the *same* record at the same
time.

This is why you'll see in Word or Excel a message that a document can only
be opened in read-only mode if it's already open, either by yourself or by
another user on the network.

HTH
-pk

 

[create_share]

Yes MS Access, Excel and word files but mostly MS Access Files. So there is
an option in Access Files?

 

[HeyBub]

Yes MS Access, Excel and word files but mostly MS Access Files. So
there is an option in Access Files?

Word and Excel, no.

Access, yes it is possible for two or more users to update the same file
concurrently - but not the same record within the file.

This is a non-trivial process inasmuch as updating a single record may
require an automatic update of several related records. For example, if a
customer record is updated to reflect a sale, the inventory, tax, and
accounts receivable records may also require updating.

 

[Patrick Keenan]

Yes MS Access, Excel and word files but mostly MS Access Files.

Word and Excel documents can be edited by one user at a time, only. A
second person could open the document as it exists, but would have to save
it under another name.

So there is
an option in Access Files?

Maybe.

If you are running in a multi-user mode, two or more users should be able to
open the same database file, but as above, only one can edit a given record
at a time, and this can include related tables. The more complex the
database structure becomes, the more complex the locking rules become.

The bottom line is that this isn't trivial and you if you need it you need
to have it implemented properly by someone who knows what they are doing and
why.

HTH
-pk

 

[Bob I]

Look up "Shared file" in Excel Help, there are some features disabled in
that mode.

 

[Phisherman]

Hi!

Is it possible for 2 or more users to work on a shared files simultaneously
and save it.

Or is there any utility that can do this job?

Thanks!

Hope not! When an editor opens a file, typically it makes a copy to
work on just in case there is a crash during the edit. If two users
opened the same file, each would make a copy of it. The last person
who saved the files would write over the other person's saved changes.
To do it properly, an editor needs to lock a file before opening it
for changes.