General Question

JonIngram's avatar

What is the next database upgrade after MS Access cannot handle the amount of data you have to process?

Asked by JonIngram (10points) September 6th, 2010

I have 1M+ records I need to be able to quickly manipulate and group for analysis. Looking for recommendations for a light weight tool as the team I manage are somewhat technically savvy but at the end of the day are more finance professionals than IT professionals.

Observing members: 0 Composing members: 0

2 Answers

JonIngram's avatar

SQL Express I heard was a good option and it is free.

JonIngram (10points)“Great Answer” (1points) Flag as…
jaytkay's avatar

Yep, SQL Server Express is an excellent free step up on the backend to hold and process the data. On its own SQL Server Express does not have much of an interface. It is usually used with something like Access, a web application or a custom Windows application on the front end for display, data entry, reporting, etc..

From within Access, that’s called a Microsoft Access project (.adp), using MS Access 2003 or later, it’s an option when you create a new database.

jaytkay (25810points)“Great Answer” (1points) Flag as…

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther