CODEWITHSUNDEEP
vb.net
Joe
Joe

Reputation: 3089

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?

Upvotes: 0

Views: 2414

Answers (3)

Mark
Mark

Reputation: 11

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

Upvotes: 1

x77
x77

Reputation: 737

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

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

Upvotes: 1

Wade73
Wade73

Reputation: 4509

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.

Upvotes: 4

Related Questions