troubleshooting Question

Sustainability of excel (VBA) - SQL server 2008 App for large number of users

Avatar of cynx
cynxFlag for India asked on
Microsoft SQL ServerVisual Basic ClassicMicrosoft Excel
4 Comments2 Solutions591 ViewsLast Modified:
Currently we have a vba application with Excel front end and sql server 2008 database which performs complex calculations and loads/saves large amout of data to-from sql server backend.

Currently this is being used by approx 150-200 users within same country.

We are now planning to roll out this application to larger group (approx 1000 - 2000 users) across large geography (accessible within our VPN) .

1) I am no database expert, hence need few suggestions on what to be considered (technical aspects) on database and front end side for above roll out?

2) Also on other note, if we have luxury to rewrite this app in other technology what would be the best replacement (for eg. aspx - sql ?) considering this app has large number of records to be imported and processed from excel files.
ASKER CERTIFIED SOLUTION
rajeevnandanmishra

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros