How to establish connection MS Access to VB2008

Asked By 0 points N/A Posted on -


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


Best Answer by Hoting Gracia
Best Answer
Best Answer
Answered By 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.

Login/Register to Answer

Related Questions