Small Business Server

Discussion in 'Computers' started by ShiftZZ, Mar 4, 2011.

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    19,821
    Likes Received:
    35,877
    Location:
    Leicestershire
    I need some suggestions/help

    a) I have a database written in Access 2007 that is growing daily.
    b) I need to allow a number of users access to it, both in house and via the web, possibly VPN
    c) Number of users, less than 10 realistically 5

    What am I looking at?
    Software
    Hardware
    Should I consider SQL Server? ( I know nothing about it)

    Thoughts would be appreciated

    ShiftZZ
     
  2. scotjimland

    scotjimland Funster Life Member

    Joined:
    Jul 25, 2007
    Messages:
    28,934
    Likes Received:
    25,574
    Location:
    .
    Sorry Dave.. out of my league .. I'm a 'mains' man .. if I did it >>>>>>>

    :Rofl1::Rofl1::Rofl1:


    [​IMG]
     
  3. activecampers

    activecampers Read Only Funster

    Joined:
    Jul 28, 2008
    Messages:
    420
    Likes Received:
    102
    Location:
    Heathrow
    Depends :)
    How big is database, how much is expected growth, how much data throughput, what features you are using (e.g. just "database" or are you using reports etc). If your front end (IIS?) is doing all the clever bits, swapping to SQL would be easy.

    Remote access - why VPN? What is the front end for the users? Just browser? Then just publish that and keep it simple. Access User Interface? THen VPN.

    Number of users? Doing what? Reading/Writing? What front end?

    So not much info to give details....
     
  4. GJH

    GJH Funster Life Member

    Joined:
    Aug 20, 2007
    Messages:
    27,231
    Likes Received:
    34,417
    Location:
    Acklam, Teesside, originally Glossop
    Sent you an e-mail Dave.
     
  5. pablomc

    pablomc Funster Life Member

    Joined:
    Apr 20, 2010
    Messages:
    860
    Likes Received:
    235
    Location:
    Co. Durham
    Software wise and not sure how you use your database. If it is quite simple database then a sharepoint list might be an option. I have just migrated a database at work to a sharepoint list. Works a treat. Not sure if sharepoint is suitable for small deployments as its not my forte. I just use them as a tool and it offers, so much more. :Smile:
     
  6. bungy

    bungy Funster

    Joined:
    Jan 24, 2010
    Messages:
    2,246
    Likes Received:
    4,127
    Location:
    Welsh marches
    head for the cloud....get the right one and it can be much cheaper than having physical stuff to worry about
     
Loading...

Share This Page