[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

VB/SQL fast as Access/UNIX?

Which would be fastest and able to support the most users, an Access app on UNIX server or a  VB front end app on an SQL server.
0
RUSTY
Asked:
RUSTY
1 Solution
 
alokmCommented:
It all depends on the hardware config and the design of the application.
0
 
jjmartinCommented:
This all depends.  There are a lot of factors involved.  Access runs very fast but only with small databases.  As your database starts to grow, Access is going to slow down, and eventually puke and die.  It is not designed for large databases at all.  SQL server can handle large databases easily and quickly, as well as small.  SQL server is would probably be the best solution as it is designed for the distributed office environment.
0
 
rlarnerCommented:
Hey, you can run Access on Unix???? I had never heard of this!  Which platform (HP, Linux, etc.)?
If you are talking about an Access database with forms, whose tables are linked to an ODBC datasource which exists on another (unix) system, then VB could do exactly the same.  See my answer to your question http://www.experts-exchange.com/topics/bin/Q.10071919.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
RUSTYAuthor Commented:
Thanks, alokm.  I was looking for a little more (see comments jjmartin et al.)
0
 
jjmartinCommented:
So do those comments do it for you, or are you looking for a little more.
0
 
RUSTYAuthor Commented:
For my 10 points, its just what I was looking for.  
Thank you.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now