PDA

View Full Version : Solved: multi users



benong
09-30-2010, 09:27 PM
hi,
if i use excel workbook to act as a database.
if i have many users using different userform but access to the same database/workbook.
What would happen if the some users press <ENTER> to save the data into the workbook at the same time?
Will the user get error message?
Will all the data be saved into DB or only the first data saved?

Simon Lloyd
09-30-2010, 09:48 PM
In a shared workbook you have to choose which user wins the edit if both editing the same cell, if they will never edit the same cell it should be ok....but really i'd steer clear of shared workbooks they're a pain, if you need a database best using Access or some other program designed for that purpose.

benong
10-01-2010, 12:18 AM
thanks simon :)