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

tags:

vb.net

views:

answers:

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 use SQL server (don't really want to anyways) but is there a better option than MDB for flat file databases?

+3 A:

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.

Wade73 2010-07-16 12:07:00

+1, full ackMS did a good job with this one.

Turing Complete 2010-07-16 12:08:20

+1 SQL Server Express is free, and it is file-based like Access, so it's a great answer to this question. It is fine for professional use: http://stackoverflow.com/questions/180537/sql-express-for-production

MarkJ 2010-07-16 13:12:57

+1, see also http://stackoverflow.com/questions/807602/use-access-or-mysql-as-a-backend-database/807724#807724

John M Gant 2010-07-16 17:29:45

Awesome, thanks a lot!

Joe 2010-07-17 17:24:27

+1 A:

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

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

x77 2010-07-16 17:20:49

+1 for another good alternative to Access.

Wade73 2010-07-16 18:33:23

ansaurus

tags:

views:

answers:

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

related questions