Recommended database (such as MDB) type for vb.net?

We're working on a new vb.net project which will need a database with many different tables and possibly thousands / hundreds of thousands of records in each table. Is there a better option than using .mdb files? The obvious benefit of using mdb is we can use Access to view / edit easily as well.

We only have vb.net express so I don't think we can us开发者_运维知识库e SQL server (don't really want to anyways) but is there a better option than MDB for flat file databases?

If you are using VB.Net Express, then using SQL Server Express is the best option. It is much better than Access. To view the database you can either use the SQL Server Management Console (SSMS) Express or you can work with the database from VB.Net. I prefer SSMS myself. Hope this helps.

Another option: SqlServerCe Do´nt needs to run any service.

http://en.wikipedia.org/wiki/SQL_Server_Compact

VB.Net Express and SQL Server Express would be a better way to go than using Access. It's not difficult, just takes a bit of time working with SQL Server. Here's an article, with code, that shows how to get started: http://michikami.blogspot.com/2011/03/visual-basic-2010-express-sql-server.html