No of visitors who read this post: 753
Category: MS Access
Type: Question
Author: Jimm Hanson
No votes yet


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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 50932

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.