MS-ACCESS with 180k / month record

[baonks]

Dear all

I just wonder can access handle that huge record
or i should go with MS-SQL ?

any help would appreciate

[Allen Browne]

If you anticipate 180,000 new records every month, you are adding 2 million
records a year, and could be around 10 million records in 5 years.

If you have the luxury of choosing which way to go, I would suggest you
choose SQL Server--not because JET can't handle it, but because of
stability.

If you already have the database in JET, it would be possible to continue,
but it would not be my choice to intentionally design it on JET for tables
of that size.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ba****@gmail.com> wrote in message
news:11*********************@j52g2000cwj.googlegro ups.com...

Dear all

I just wonder can access handle that huge record
or i should go with MS-SQL ?

any help would appreciate

[Bob Alston]

ba****@gmail.com wrote:

Dear all

I just wonder can access handle that huge record
or i should go with MS-SQL ?

any help would appreciate

You might also make sure your database is designed properly and also
review how long you need to retain the detail records.

Bob