Multiuser concurrent application in Excel ..URGENT..

S

shivam71

Hi Experts,

I have a need to design an application which many users will use AT THE
SAME TIME- TO QUERY

, UPDATE DATA etc..

The question is that: IF MANY USERS ARE DOING UPDATES ETC AT THE SAME
TIME, THEN IS IT

POSSIBLE TO DO SO IN EXCEL?

I think that it is not possible but still I think I will check with
experts first..

Is it possible with Access?

With thanks,
Nirav.
 
J

Jerry W. Lewis

Excel does workbook level locking. One person can have write access,
the rest read-only until the first one is finished.

A database program (Access, FoxPro, Oracle, etc) can do record level
locking, where different people can change different records at the same
time.

I don't know of anything that would allow multiple people to update the
same record at the same time. If there were, I would be concerned about
how it maintains data integrity.

Jerry
 
A

Arvi Laanemets

Hi

As much as I know, it's possible only, when every user has his own workbook.
It is possible only, when every user adds/edits only his own info, and
nowhere the same info can't be entered by several users. Summary database is
generated through links, and is read-only. Any general info (needed by
several users) is edited by single user, and is available for other users
through links only, or is read into local workbook through ODBC query. I
myself have designed a couple of such projects (data input on department
level, with department workbooks on network resource, and summary
workbook(s) for management bosses on their local computers).
 
Top