|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#2
March 6th, 2006, 11:01 AM
|
||||
|
||||
|
Pretty much in the same way that you do with ASP - but you just need to be more explicit when you declare stuff. Here's the basics...
Code:
Dim DBC As ADODB.Connection 'Connection to ADODB
Dim DSNtemp As String
Dim strSQL As String
Dim RS As ADODB.Recordset
Set DBC = New ADODB.Connection
Set RS = New ADODB.Recordset
DSNtemp = "Provider=MSDASQL;"
DSNtemp = DSNtemp & "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp = DSNtemp & "DBQ=C:\DataBase.mdb;"
DBC.Open DSNtemp
DBC.CursorLocation = adUseClient
strSQL = "SELECT ExampleField FROM tblExample;"
RS.Open strSQL, DBC, 2, 3
If RS.EOF = False Then
msgbox RS("ExampleField ")
Else
msgbox "Nothing There!"
End If
__________________
LozWare Website Directory Whooo! Free submissions, no recip needed. I'm a nice guy 
|
|
#3
March 6th, 2006, 03:39 PM
|
|||
|
|||
|
You should use the newer Jet OLEDB database drivers, you can find examples at www.able-consulting.com
The MSDASQL driver is, I think, being phased out by MS, and using the older ODBC drivers is more prone to problems. Also you need to add a reference in your VB project to ADO. VB6 has a whole lot of databound controls, you can do all the database connections using controls rather than code if you prefer. Refer to the VB documentation.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#5
March 6th, 2006, 10:37 PM
|
|||
|
|||
|
Quote:
Everyone is entitled to an opinion, right or wrong.
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > How i can connect access with vb? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
How i can connect access with vb?
Linear Mode
