Hosting files on a Win 7 workstation

intelogent
intelogent used Ask the Experts™
on
Hi,

We use a Relational Database for our insurance business. I have been told that this file can be shared by upto ten users at once on our network.
We are peer to peer.  if the work station hosting the database is using it, would that lock out other workstations which had permission to access it?
and also could the other workstaions simultaneously use it too?
what would be the benefit of hosting it on  a Server 2008  VS  a dedicated Win 7 work station?   woul d either be faster file sharing or superior in any ways?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Surely it depends which database software you are using and whether it implements file level or record level locking on shared files ?

Author

Commented:
i will address that specifically
Commented:
Also it depends on how your application opens your database. File permission has nothing to do with locking of databse. If file permission allows to open, you should be able to open it unless it is locked by the application.
Commented:
Windows 2008 allow more than 10 users to connect to the share
Access for example can be shared on the server to allow multiple user to access at the same time
shared folder permission is required because unlike the flat file like excel openning the file is not copied to memory if you give the user read only he will not be able to open it
for locks system create a new lock file so user require modify permission on the folder
Commented:
Much more convenient and efficient to host the database on a networked NAS.
A real pain when working on or rebooting the hosting workatation and you can't always put it off
for after work hours.

Author

Commented:
sorry,

what is a NAS?

Commented:
Comes in many flavors. A simple  network unit will do. Many flavors on the market.

http://en.wikipedia.org/wiki/Network-attached_storage       More info than you may want

http://www.buffalotech.com/technology/standards/nas/   Some configurations

http://www.buffalotech.com/products/network-storage/home-and-small-office/   some products

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial