Question about Access database and VB6 [resolved]

Printable View

Sep 19th, 2005, 04:43 PM
just_a_me

Question about Access database and VB6 [resolved]

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?
Sep 19th, 2005, 04:50 PM
RhinoBull

Re: Question about Access database and VB6

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

http://www.vbforums.com/search.php?searchid=373082
Sep 19th, 2005, 05:02 PM
just_a_me

Re: Question about Access database and VB6

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.
Sep 19th, 2005, 05:04 PM
randem

Re: Question about Access database and VB6

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.
Sep 19th, 2005, 05:09 PM
RhinoBull

Re: Question about Access database and VB6

Quote:

Originally Posted by 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.

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

Beginning Visual Basic 6 Database Programming
Sep 20th, 2005, 05:40 AM
Hack

Re: Question about Access database and VB6
Quote:

Originally Posted by 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?

Here is a start.
VB Code:
```
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.
Sep 20th, 2005, 09:22 AM
just_a_me

Re: Question about Access database and VB6

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