MS Access database

Question

MS Access database

Ed7

SSCrazy Eights

Points: 8519
More actions
September 8, 2009 at 8:24 am

#385323

Hi Everyone,
Would be a good idea to have Microsoft Access for storage and backend database for
a logging and notification systems applications?
Estimations the records can grow over 2 millions over couple months.
Personally, I did not favor MS Access compare to Microsoft SQL Servers due to MS Access storage limitations.
Can somone please provide me some advice and suggestion on MS Access limitations?
Thanks,
Edwin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Simon AV SSCommitted Points: 1551 More actions · Answer 1

Data size is going to render the access database unusable very quickly. How long do you need to store data in the database ? If more than a couple of month then surely SQL is the way forward. The Express editions are free !

Useful link http://articles.techrepublic.com.com/5100-10878_11-6140859.html

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 2

Hi Simon,

Thanks for the links. Yes, I aware of the SQL Express edition is free.

I need to convince the Analyst of Microsoft SQL Server 2008 over MS Access 2003 or 2007.

The data will be residing in database for minimum 1 ++ years.

-Edwin

Simon AV SSCommitted Points: 1551 More actions · Answer 3

We are going to biased on here by the very nature of the board ! But with the datasize you are looking at it shouldn`t be that hard to convince anyone that SQL is the way forward.

Additional functionality, cost, support etc all win out for SQL.

Silverfox SSC-Insane Points: 23150 More actions · Answer 4

You will have performance issues if your database is going to grow by millions of records on a monthly or bi-monthly basis. access is not known for handling large databases that well and if you have a lot of users for this application, you could end up with a lot of problems.

SQL Server will be the better option for reasons given by previous posts.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]