• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 836
  • Last Modified:

Open MDB file in VB.NET 2008

Hello guys,

I an new at .net :P and I need to open a database as soon as the main form loads.

This database should stay opened on every form or while the program is executed. I used to do this on a module when I progammed in VB 6, but I have no idea on how to do that with VB.NET.

Any suggestions?

Thanks.
0
pvg1975
Asked:
pvg1975
2 Solutions
 
jppintoCommented:
You don't need to "open" the database, just append the database to your project and "open" a connection to the database everytime you need to get or save data to the database. Then you close the connection until you need to open it again.

Please take a look at some of this articles to get you started:

http://visualbasic.about.com/od/learnvbnetandadonet/l/aa041203a.htm
http://www.developerfusion.com/article/4286/an-introduction-to-vbnet-and-database-programming/
http://www.astahost.com/info.php/Vbnet-Ms-access-Interaction-Tutorial-Part_t12054.html

jppinto
0
 
AshokCommented:
Imports System.Data.OleDb

.....

On Main Form Load

  Dim statement As String
  Dim SQLStr As String
  Dim conn As OleDBConnection
  Dim cmd;

  conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\Program Files\Helios11\Data\Link.mdb';Persist Security Info=False;")  
 
  conn.Open()

When you no longer need connection open,

conn.Close();

HTH
Ashok
0
 
pvg1975Author Commented:
Thanks guys :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now