We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

VB/SQL fast as Access/UNIX?

RUSTY
RUSTY asked
on
Medium Priority
134 Views
Last Modified: 2010-04-30
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.
Comment
Watch Question

Commented:
It all depends on the hardware config and the design of the application.

Commented:
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.

Commented:
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 https://www.experts-exchange.com/topics/bin/Q.10071919.

Author

Commented:
Thanks, alokm.  I was looking for a little more (see comments jjmartin et al.)
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
For my 10 points, its just what I was looking for.  
Thank you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.