View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
unplugs[_26_] unplugs[_26_] is offline
external usenet poster
 
Posts: 1
Default Multiple Access in Excel ???

After I finished create the user form and all the function used t
calculate the working hours, I get stuck on this issue.. Is it th
spreadsheet with userform are multi-accessed by users?

Can I know who can answer my question?

Case 1:
Employee A and Employee B open the spreadsheet, filling up th
userform. The entries in userform will straight away pass t
spreadsheet behind the userform. If Employee A saved the fil
first...and Employee B still making the entries, is it when Employe
save the file later will overwrite the previous file that Employee
had saved?

Case 2:
Employee A access the file first, make some entries inside.... The
employee B comes in and make some entries(In the spreadsheet alread
have some entries that A made).... After that employee B saved the fil
before employee A do so. The entries that the employee A made withi
the period of B comes in and leave will lost or not ?

Can Excel handle multiple access? The shared workbook works... but I
juz allow 1 user make entries each time.

So, is it any possible solution for this... if juz using Excel? I'
getting headache man..

--
Message posted from http://www.ExcelForum.com