DAO in VB .NET MS ACCESS Database

How to connect Access Database using DAO In VB  .Net

vb .net DAO
vb .net DAO

Data Access Object (DAO)

According to Microsoft Docs , Conversion from DAO TO ADO : Versions of the DAO library prior to 3.6 are not provided or supported in Access.

ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
DAO is used with Access databases and is supported through Office 2013. DAO 3.6 is the final version, and it is considered obsolete. These classes work with the other application framework classes to give easy access to Data Access Object (DAO) databases, which use the same database engine as Microsoft Visual Basic and Microsoft Access. The DAO classes can also access a wide variety of databases for which Open Database Connectivity (ODBC) drivers are available. Programs that use DAO databases will have at least a CDaoDatabase object and a CDaoRecordset object.

DAO 360 dll

  • Data Access Object Version 3.60
  • Path : C:\WINDOWS\assembly\GAC\dao\

vb .net Project Design

  • Create new visual basic Project - WinForm
  • Create new MS-Access 2003 Database

Visual Basic .Net Project

  • New form  (Name :Form1)
  • DataBase  (Name : ahmed.mdb)
  • Add Reference : COM => DAO 3.61
vb .net Dao 360 dll reference
vb .net Dao 360 dll reference

Code

Imports DAO
Public Class Form1
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim DB As DAO.Database
Dim DBE As New DAO.DBEngineDB = DBE.OpenDatabase("ahmed.mdb", Nothing, False, "dbase iv;")
End Sub
End Class
And you have just connected your database *.mdb in vb.Net Using DAO 3.61

Using Dao 360 with Microsoft Access 2007 / 2010 / 2013 / 2019 (*.accdb)

1) How to get all Tables in a Database using DAO 360

  • Create VB .Net WinForm Project
  • Add Module [DaoConnection]
  • Add Reference to Dao 360 dll
  • Create MS Access Database 2007 / 2010 / 2013 / 2019 [db.accdb] in [C:\Databases\]
  • Encrypt Database [db.accdb] with Password [MyPassword]

2) How to get all Fields in Database using Dao 360

Using the above example, this code will enumerate the Tables-> Fields -> Attributes
Code


♥ Here are some online Visual Basic lessons and courses :
Location: Middle East

Popular posts from this blog

Visual Basic Online Courses DataGridView Add Edit Delete

Image
VB .NET DataGridView Add Edit Delete Manipulate DataGridView from Visual Basic 2010 with SQL Server Visual Basic Online Course - DataGridview SQL Server Database Note :   If you don't know how to work SQL Server With VB .NET : You need to see  this  then  this Logic Using DataGridView Control In VB .NET to Add New - Edit - Delete from/to SQL Server Database or MS-Access or any other Database type. You will find in the end of the lessons the project to download along with source code .  Design 1) Create a new Visual Basic project (Windows Application) name it as (MyDg1) and save it to your hard drive. 2) Place a DataGridView Control on the Form1. 3) Create SQL Server Database file, name it (MyDB) 4) Create Table, name it (Kinds) with just one record, name it (Kinds) 5) Rename the DataGridView Control's name From (DataGridView1) to (DG1) 6) Save/Build the project . 7) Now you have: A project such as this one in the 3 photos (from insid
Continue Reading >>

Visual Basic 2010 Working With DataBase Full Project Example

Image
VB 2010 Book Working With Database Full Project Example Download VB 2010 Book to work with MS-Access Book Link via MediaFire.com The book is 5 chapters and is explained here, it contains source code of a project example on how to work with Microsoft Access Database from Visual Basic 2010 .     In the book; the photos show how to start your project, how to select your database and how to display it. Here, we'll discuss each photo and explain each code block. Chapter#1 - Released VB .Net 2010 Working With DataBase Full Project Example     Photo (1) : Shows the folder that contains the project, the (My-First-Con.vbproj) is the icon you need to click to open the project.     Photo (2) : From menu (Data) choose ( Add New Data Source ), a popup dialog-box will show titled (Choose a Data Source Type) and you select (Database) as long as we are connecting to one, then click next.     Photo (3) : A popup dialog-box appears titled (Data Source Configuration) an
Continue Reading >>

VB .NET WebView2 WinForms tips

Image
VB .NET WebView2 WinForms Tips Edge WebView2 Tips Edge WebView2 Intro This course blog discusses dealing with Microsoft Edge WebView2 Control. If you are a developer then I'm sure you have searched before for an alternative WebBrowser Control, especially if you are a Desktop Apps Developer. Edge WebView2 Control by Microsoft gives you the ability to Embed Web Technologies like (HTML, CSS, JavaScript, …, etc.) in your App. It uses rendering engine Microsoft Edge (Chromium), so you can Display the web contents in your Apps. Requirements In order to start Microsoft Edge WebView2 for Desktop Projects as alternative for WebBrowser Control, you need the following : Microsoft Windows (In my case, it is Win10 64bit) Microsoft Visual Studio (In my case, it is VS2017) WebView2 Runtime or any Microsoft Edge (Chromium) non-stable channel installed on supported OS (currently Windows 10, Windows 8.1, and Windows 7). (In my case, Win10 64bit and Microsoft Edge (Chromium)
Continue Reading >>

VB NET Check internet connection

Image
 Check Internet Connection using VB 2010 Using VB.NET to check Internet Connection status This is a very simple example of how to check if there is an internet connection available for your machine (LapTop, PC) using VB 2010 Programming Language . - Project Design : 1) Create new project, (save it) 2) Create new Windows Application form (Form1) 3) Place a Label (Label1) and Timer (Timer1) on your Form (Form1). VB.NET Check Internet Connection - Coding In the following VB.NET Code I'm using two Functions to ( Boolean ) : Check internet connection using  Computer.Network.Ping( "google.com" ) Check internet connection Using stream = client.OpenRead( "http://www.google.com" ) ♥ Here are some online Visual Basic lessons and courses : Visual Basic .Net snippets collection Visual Basic .Net - How to check for the internet connection Visual Basic .Net - POP3 and Receiving E-mails Visual Basic .Net - Generate Random Combi
Continue Reading >>

Visual Basic .Net - Button Sound / Music Play

Image
Visual Basic 2010 - Button Sound Visual Basic 2010 - Play sound on buttons The code is simply goes like this You can copy and paste in your (Click_Event) or whatever it is you wish (MouseClick - MouseHover - MouseLeave) : Dim  MySound  As   New  System.Media.SoundPlayer()     MySound.SoundLocation =  "path to the .Wav file" MySound.Load() MySound.Play() ' OR you can use this : Sub PlaySystemSound() My.Computer.Audio.PlaySystemSound( System.Media.SystemSounds.Asterisk)   End Sub Background playing   It lets the application execute other code while the sound plays. The My.Computer.Audio.Play method allows the application to play only one background sound at a time; when the application plays a new background sound, it stops playing the previous background sound. You c
Continue Reading >>

Visual Basic 2010 Math Functions

Image
Microsoft Visual Basic 2010 Math Functions Visual Basic 2010 Math functions Math and String Functions In addition to performing simple arithmetic and string operations with the arithmetic and string operators, Visual Basic programs can take advantage of several built-in  mathematical functions  and  string functions to perform useful processing that, otherwise, could require highly complex original code. Mathematical Functions Popular mathematical functions are summarized in the following table. Note that certain functions do  not  require the  Math.  prefix. Function Use Math.Abs() Returns the absolute value. Math.Abs(-10)  returns  10 . Math.Ceiling() Returns an integer that is greater than or equal to a number. Math.Ceiling(5.333)  returns  6 . Fix() Returns the integer portion of a number. Fix(5.3333)  returns  5 . Math.Floor() Returns an integer that is less
Continue Reading >>