Connecting to MS Access DB using Data Control - Visual Basic , VB.NET

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

Connecting to MS Access DB using Data Control
Author: Gibb Philip B. Manaog
Website: http://www.mandrix.tk
Submitted: 1/28/2006
Version: VB6
Compatibility: VB5, VB6
Category: Databases
Views: 22704
This snippet will connect your application to your MS Access version 7 using Data Control... email me for further assistance... i am willing to help.....
Declarations:
Dim vDatabaseName as String Dim vRecorsource as string
Code:
'First you must add a Data object to your application.. ' Data object can be found at your defualt toolbox.. 'Name your Data Control as dtaDatabase 'Copy this code to your Form_Load function... vDatabaseName = "your database goes here (eg. c:\somepath\db1.mdb" vRecordSource = "the table you are about to connect" dtaDatabase.DatabaseName = vDatabaseName dtaDatabase.RecordSource = vRecordSource dtaDatabase.Refresh 'send me your comments....