How to establish connection MS Access to VB2008

Asked By Jimm Hanson 0 points N/A Posted on - 03/22/2012

Hello,

I have created the following:

1 Form created in VB2008

3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record]

2 Database created in MS Access 2003

File Name: Information.mbd

Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number]

How to create connection? How to get data on form load from database in Textboxes? How to insert, update, delete data? Please provide information as I am not able to get any simplest way to understand these questions.

Thanks in advance

 

• Status: Open
• Question Views: 1149
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Hoting Gracia

Go To Solution

Best Answer

Best Answer

Answered By Hoting Gracia 5 points N/A #118921

How to establish connection MS Access to VB2008

Hello Jimm!

Visual Basic is a language of .net which is developed by Microsoft and this language is similar to C and also it is majorly used in many programs for smooth execution.

 

Coming to Windows Application Form in Visual Basic it is simple as it is drag and drop and no need to generate any code for that as automatically code will be generated.

 

Remember the following 5 objects that are required in connecting to database which can be described as Connection, Command, DataReader, DataSet and DataAdapter.

 

To perform database with the data then you simply create a connection for database and then insert your queries and you can access data from the database.

 

Thank You.

 

About Hoting Gracia

Questions
0

Answers
154

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 03/22/2012
• Question Category: MS Access