Acess file - sharing within LAnetwork

  • Thread starter Thread starter JLEE
  • Start date Start date
J

JLEE

Hi, need some comment & help,
I have a acess file sharing in networks:-
a)when 2 person open the file, it is deem that both can edit the data. But
when come to saving, who's will it saves ??? or what's happen when both saves
at different timing ???
unlike Excel, only one person can read and write at the same time. the other
person can only open as read only.
Any advice on this matters ???
Tks in advance.
 
Hi,

Access is designed to deal with those situations. You can test it out
yourself by opening up two instances of the same database on your computer,
pulling up the same record in both, modifying in one and saving. Then
modifying in the other and saving. Or by modifying in one, modifying in the
other, saving in one and then in the other. See what it does.

Clifford Bass
 
The difference between a product like access and excel, is that excel has
the whole worksheet loaded into one users workspace, and one change
equires the person to save Absolutely everything contained in that
worksheet.

In MS access it does not work with the whole file, but only works with
what's called bits and pieces of the data at one given time (a reocrd). What
this means is that two users can work on the file the same time, but they
only work on a small piece of the file, and all the other bits and pieces
can be worked on by other users. The instant you close a form or move to
another record that piece of data you're working on is saved to the hard
drive. Therefore you'll notice that when you exit MS access there is no file
save at all. So MS access does not work on the whole file, in fact works on
some little tiny pieces at a given time. This is also why access can be
significantly faster than Excel when dealing with large number of reocrds
(rows) because you're allowed to work with one row of data at a given time
(and therefore MS access only has to load that one row out of say 500,000
rows)

The only time there becomes a problem if two users try to edit the exact
same record or piece of information at the same time, in this case you
simply get a message that someone else's changed your data and you have a
choice to overwrite it, or ignore the changes. You can even set the form to
actually lock the record to prevent any other user from editing the date it
the same time, so both cases you're pretty safe in this scenario.
 
I have a acess file sharing in networks:-
a)when 2 person open the file, it is deem that both can edit the
data. But when come to saving, who's will it saves ??? or what's
happen when both saves at different timing ???
unlike Excel, only one person can read and write at the same time.
the other person can only open as read only.
Any advice on this matters ???
Click to expand...

What is your question?

When 2 people edit an MDB file, as long as they are not editing the
same record, both of the changes will be saved. If they edit the
same record, they will be notified and offered options as to how to
handle the write conflict. But with optimistic locking, they are
unlikely to see even that.

Are you wondering how to make Access behave like Excel? Pessimistic
locking would be one way to do that, but it will work only on a
record-by-record basis. I don't know why you'd want to do that,
since it makes it harder to use.
 
Back
Top