Small Business Server (1 Viewer)

ShiftZZ

LIFE MEMBER
Feb 19, 2008
21,383
84,541
Dark Side of the Moon
Funster No
1,546
MH
A class
Exp
Since 2007
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
 

scotjimland

LIFE MEMBER
Jul 25, 2007
2,299
9,951
Funster No
15
MH
A Woosh bang
Sorry Dave.. out of my league .. I'm a 'mains' man .. if I did it >>>>>>>

:ROFLMAO::ROFLMAO::ROFLMAO:


tykrykjfgjkftdd.jpg
 
Jul 28, 2008
813
731
Wiltshire, UK
Funster No
3,483
MH
Ducato Sportivo
Exp
Since 2005! 2000+ nights so far...
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....

Subscribers  do not see these advertisements

 

pablomc

LIFE MEMBER
Apr 20, 2010
772
237
Durham
Funster No
11,161
MH
A Class
Exp
Since 2009
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:
 
Jan 24, 2010
2,440
4,848
Funster No
10,065
MH
Adria Twin
Exp
Since 2007
head for the cloud....get the right one and it can be much cheaper than having physical stuff to worry about

Subscribers  do not see these advertisements

 

Join us or log in to post a reply.

To join in you must be a member of MotorhomeFun

Join MotorhomeFun

Join us, it quick and easy!

Log in

Already a member? Log in here.

Latest journal entries

Funsters who are viewing this thread

Back
Top