|
![](/i/fill.gif) |
>> Actually, I think nowadays you can set it up for multiple edits and
>> it'll coordinate.
>
> I've never seen that.
It's under the Review ribbon, then "Share Workbook". But it only lets
you change basic stuff when shared (ie just cell contents, not the
layout, charts, etc), and the changes are only updated when you save the
file (or I think you can set it to automatically update at regular
intervals). If two people change the same cell, the first one to save
will succeed, the second one will get to choose which value to keep.
>> Last I looked, Access was only one user at a time making changes too.
>> The one guy would lean back in his chair and bellow "IS THERE ANYONE IN
>> THE DATABASE?" That was their locking protocol.
>
> I spent six months watching a group of three people in an office. They
> had an Access database, which everybody had constantly open all day. So
> clearly that's not the case.
I only worked on Access about 8 years ago so it's probably out of date
info now, but IIRC you could set up on a per-table basis how much of it
was locked when opened (entire table, single row, nothing). It also
took a fair bit of work to get it to play nicely with multiple people
opening it (ie catching all the errors that might come up, and
preventing people doing stuff that would screw it up).
Post a reply to this message
|
![](/i/fill.gif) |