Hi,
Dim cn As ADODB.Connection
Set cn=New ADODB.Connection
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB. 4.0;" & _
"DataSource=D:\ProgramFiles\MicroSoft Visual Studio\VB98\inventory.mdb"
CN.Open
Try This Title: "Develop an Inventory Management Application Uisng Microspft's Visual Basic" (Access as a backend)
Hope this helps.
Regards
bhar
Hi Everybody
I am tring to connect the vb code to ms access databse using ADO method.
and its gives the Compile Error : user defined Data type is not defined.
i have declared the following and complier highlights the declaration.
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command
please help
Nee123