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.
 
We had a similar problem for a client we did this for. In the end they whent for a web based one.

Speed wise there wasnt much data being returned after each transaction so speed wasnt really an issue.

The best thing about the web based solution is you dont have the hassle of installing/updating machines when you make an update find bugs etc.

A downside of the web based one is potentially if you only have one web server and that goes down then the whole system could go down. So what we have is a couple of backup servers that it rolls onto if the main one goes down.
 
Paul11 said:
are there no advantages to the access front end system ?

(apart from that it will be slightly cheaper)
Click to expand...

Cheaper. Faster to develop and change in the future. The web server isn't a single point of failure (unless you implement resilience). For a small business then an Access front end is fine. But personally I'd go for a web based solution.
 
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)
 
i would go web, may as well

we have a number of things running on access that have been bastardized into place now as they were originally short term solutions but about 3 yrs later they are still running
 
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.
 
Web based is great for non-install (desktop app) accessible for anywhere remotely. You would have to beef up security tho. Nature of the web allows access from anywhere. Web code updates only need to be rolled out the webserver.

Access front end (i'm assuming that its a desktop app) would be slightly more secure as its not a generally accessible front end. Harder to update as it needs to be pushed out to all the clients. Not as accessible as you need the desk top app installed first.

Speed issues would be similar on both and backups would come part of the remote SQL server?

My opinion, I would go web based.
 
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
 
It's very limiting. It has non-standard SQL implementation. It is weak at joins. If you try to store/view more than a certain number of rows, it becomes very unstable (to the point of it simply crashing repeatedly.) It uses VBA. *spit*
 
You must log in or register to reply here.
Back
Top Bottom