Question about Access database and VB6 [resolved]

[just_a_me]

I'm completely new to databases so I'm not sure where to start. I made a table in Access 2003 and I created a datagrid that is connected to it using the wizard, but I want to insert records and create a connection without using the dataGrid. I've tried searching for a tutorial on this, but maybe I'm looking in the wrong place. Can anyone point me in the right direction to look in?

[RhinoBull]

There are numerous threads out there so here are some of them:

http://www.vbforums.com/search.php?searchid=373082

[just_a_me]

I asked the question because I haven't found what I needed by doing similar searches on the forums. While I'm not new to programming, I'm new to databases as of today and need a very fundamental place to start. I guess I'm off to the bookstore then.

[randem]

just_a_me,

Take a look at my signature for the Multi Database Connection. It should help you. Also read Database Problems in my signature too.

[RhinoBull]

I asked the question because I haven't found what I needed by doing similar searches on the forums. While I'm not new to programming, I'm new to databases as of today and need a very fundamental place to start. I guess I'm off to the bookstore then.

I understand... The following book could be a good start.

Beginning Visual Basic 6 Database Programming

[Hack]

I'm completely new to databases so I'm not sure where to start. I made a table in Access 2003 and I created a datagrid that is connected to it using the wizard, but I want to insert records and create a connection without using the dataGrid. I've tried searching for a tutorial on this, but maybe I'm looking in the wrong place. Can anyone point me in the right direction to look in?

Here is a start.

Dim ADOCn As ADODB.Connection
Dim ConnString As String
 
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=c:\YourMdbName.mdb;" & _
        "Persist Security Info=False"
 
Set ADOCn = New ADODB.Connection
ADOCn.ConnectionString = ConnString
ADOCn.Open ConnString

The only thing you need to make this work is a reference to the Microsoft ActiveX Object Library.

[just_a_me]

Thanks guys. That's what I needed. I found that book at the library too.