Access with a very big table - will Microsoft: Access take it ?

[Sam443]

I'm planning to create an access database with a table in it that may have 20 million lines in it. Does anyone know if Access will be able to deal with it, or will I need to use another DB ??

 

[Ladi]

Access would probably be able to crawl through it, but I would certainly recommend looking into higher-end solutions such as a SQL db or even Oracle. Keep in mind that it doesn't hurt to start in Access, as it can import into any modern DB out there...

~Ladi

 

[Sam443]

Thanks, Ladi