Database connectivity (MS_Access)

[Ram15]

I am relatively new to VB programming. Could anyone please help me in getting database connectivity in VB. I am actually using MS_Access as my database.

And also could U please tell me how to replicate a form record(combination of controls) at run time.

Thanks and Regards
Ram

[Kethees S]

first, you have to have a data environment.
from menu: project ->data environment
right click on connection and select property
selsect ms jet 4.0 OLEDB provicer
select your database
click on test connection
if you are connected, then you are connected to the database

if you need to do any insert or quary at run time, let me know, i will send you some sample code.

rgds,
kethees

[Nilesh_S_Gokhal]

Hi

try connecting with the OLEDB

Dim dbconn as ADODB.Connection

Set dbconn =new ADODB.Connection

dbconn.open "Provider=Microsoft.jet.oledb.3.51/4.0;Data Source=" Path of your MDB File"


Pls Tell me does this work

[JeffB]

I suggest you use ADO (ADODB). This is a powerfull database collection of objects. Now, there is ADO.NET, but ADO is still a lot used in the industry, this is a sure value.

Also, I suggest you find a book about ADO (ActiveX Data Objects) and Visual Basic. You will want to learn from the basis, and database programming might be hard. Also, you can use ADODC control to make a connection to a database. ADODC use ADO, and ADO use OLEDB, but anyway, find a book, there is some tutorials and example on the web, but nothing like a well written book. Search the forum for links, you may find interesting tutorials

JeffB