• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

file share question

If one person is working on a document on the server and another person tries to access that document and make changes at the same time what will happen?  Will the two be overwriting each other's work unknowingly or will an error message pop up for one of them?  
0
bjv211
Asked:
bjv211
  • 3
  • 2
2 Solutions
 
sirbountyCommented:
Depends on the application.
Excel for instance, will prompt the 2nd user to open the file as read-only, or offer to notify the user when it becomes available.

A simple text file however, may allow two users to open it at the same time.  If user 1 closes and saves, and then user 2 closes and saves - user 1's data is lost.
0
 
bjv211Author Commented:
i heard that access will merge all edits together upon the last close, is this right?
0
 
bjv211Author Commented:
one more thing:  is it adviseable to allow large video files to be moved to a file server durning peak use  (1 windows server box w/ 1 NIC)  Does the overall load balance out or will the large videos hog the bandwidth?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Steve KnightIT ConsultancyCommented:
Access is a database.  It is designed for multiple access so users accessing different records is OK by design.  Only one can change the design of the database -- i.e. new tables, fields etc. as that needs exclusive access.  An app. normally places a lock on a file that is open -- you can see how a file is open in the shared folders part of computer management on a server.

Steve
0
 
bjv211Author Commented:
any thoughts on this b4 i close?

one more thing:  is it adviseable to allow large video files to be moved to a file server during peak use  (1 windows server box w/ 1 NIC)  Does the overall load balance out or will the large videos hog the bandwidth?
0
 
Steve KnightIT ConsultancyCommented:
Sorry, missed the extra comment before... The large files may quite easily hog all the bandwidth though not to the point that the server will stop serving other users but it is likely there use would slow doen.  You might want to look at Windows 2003 R2 which has built in facilities for limiting saving of certain file types etc. to shared drives.


If you have certain users who are likely to save such files at a basic level you could limit the speed their end by putting them on a 100 or even 10 meg port when the server is on gigabit or  put them on a different nic card connected to a different segment.

hth

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now