which is better database option?

Paul11

Paul11

Paul11

Soldato
Joined
28 Sep 2003
Posts
10,414
Location
London
which of these two otions is better/faster/more ideal

to run a company tracking orders, despatch, invoicing, products.

a) access front end linked to SQL server

b) web based solution running SQL server


goal is to be able to log in from different locations


is there a big difference in performance, scalability, speed or any other things to take in to consideration ?

thanks in advance.
 
Hades said:
The web server isn't a single point of failure (unless you implement resilience).
Click to expand...

thank you

but with an access front end there would still be an SQL database hosted somewhere as the backend so that would still be a single point of failure, wouldnt it?

also, there will only be 3 users, maybe growing to 4 or 5 in the future.

from a speed perspepctive will they be any different ? (access/SQL or webbased)
 
thank you all

looking in to the cost of both options now

seems the access route is quite a bit cheaper but still reviewing it all

appreciate all the advice.
 
Spunkey said:
Why would you use Access as a front end to SQL server? It's like having a brand new 50" Plasma TV and watching it through your letterbox.
Click to expand...

how so, i thought speed and performance wise would be similar

yet setup costs for access would be less
 
You must log in or register to reply here.
Back
Top Bottom