Server or Regular XP box for Access Database Sharing?!

Tazman2

Supreme [H]ardness
2FA
Joined
Nov 17, 2000
Messages
5,030
Friend of a friend wants to share an Access database with upto 6 people. Do i even need a server for this? Or can i just set it as a shared database and just put it on a decent raided XP box? It is a somewhat larger database then usual at 2-3 GB each as theres about three of them. His budget is under $1,000 if possible NOT including monitor, etc. as it'll just go into a closet, etc. Thanks! :)
 
For few users, servers are overkill. You can run up to ten users on an XP Pro box. A decent CPU and memory with good drive speeds are all you need unless they are running software that generates a lot of DB load.

Servers with dedicated server software are advantageous for large numbers of users, centralized administration and heavy loads.
 
For that buget an xp pro box will do. Personaly once you hit 5 or so machines I prefer to run server for the ability to centraly manage them.

Either way a raid 1 or 5 and a backup solution is needed.
 
Yeah i figured atleast run raid 1, etc. Do you suggest setting up access by user or just leave said directory fully open as i assume all the users in house will be using it without any restrictions, etc. Also, is there anything special that has to be done to the Access databases so that sharing works well/correctly? Thanks.
 
Yeah i figured atleast run raid 1, etc. Do you suggest setting up access by user or just leave said directory fully open as i assume all the users in house will be using it without any restrictions, etc. Also, is there anything special that has to be done to the Access databases so that sharing works well/correctly? Thanks.

If you are running peer to peer then just leave the guest account off and add in the user accounts and passwords to the "server"'s user accounts the same as they are on the workstations. That way only those users can get to the share.
 
Buy a NAS and be done with it. No need administering a server for the simple purpose of file sharing. Waste of CPU/RAM and electricity.
 
Buy a NAS and be done with it. No need administering a server for the simple purpose of file sharing. Waste of CPU/RAM and electricity.

Unfortunately most cheap NAS's are well crap. Either low transfer rates, things stop working shortly after, etc. I remember doing some research for something decent for work and there was alot of issues with them unless you spend over a grand pretty much so that won't really help me! :(
 
As a network administrator for two different companies, I can say that their are great benefits to using Windows Small Business Server 2003 over XP for serving. But if ALL you want to do is file share, then just get a dedicated NAS for it.
 
Unfortunately most cheap NAS's are well crap. Either low transfer rates, things stop working shortly after, etc. I remember doing some research for something decent for work and there was alot of issues with them unless you spend over a grand pretty much so that won't really help me! :(

ReadyNAS works fine. They have 4 disk models that run under $500, then you just need to add drives.

I built my own, but I had special needs (automated tape backup, SCSI, etc.).
 
ReadyNAS works fine. They have 4 disk models that run under $500, then you just need to add drives.

I built my own, but I had special needs (automated tape backup, SCSI, etc.).

Hmm not bad. Do you have to put in 4 already or is it UPTO 4? And is it all raid, etc. as well?! :)
 
Hmm not bad. Do you have to put in 4 already or is it UPTO 4? And is it all raid, etc. as well?! :)

Infrant uses XRAID, which stands for "eXpandable RAID". You can buy four disks now, and upgrade the drives one by one to make a bigger array once those 1TB drives are cheap. Or just put one drive in now, and add them as you go for parity and extra space.

It's actually pretty nice and no OS to update/manage/patch/repair. (well it does have an OS but not one you need to worry about).

Look for the NV or NV+ models.

*But even this is overkill for what you are doing. Just buy a single disk NAS enclosure and make sure you back up the database to another PC every day and maybe burn a CD and take it home, or even a usb flash disk. I can't see your Access database taking up more than a gig anyway, so a four disk raid 5 is pretty useless.

*D-Link makes a nice 2 disk model with gigabit, its DNS232 or something like that, I don't remember the model name. It has alot of stuff built in as well
 
Back
Top