Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help required retrieving info from a table using OpenRecordset

Status
Not open for further replies.

bobgg

Programmer
Jul 1, 2002
7
0
0
GB
Hi Everyone, I am a new programmer trying to access a table
called "CUSTOMER DETAILS" in MsAccess. the code I have already is:-

Private Sub LOGINOKBUTTON_Click()
Set dbase = New ADODB.Connection
Set dbasers = New ADODB.Recordset

dbase.CursorLocation = adUseClient
dbase.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\cab\info.mdb"
dbase.Open

If Not dbase.State = adStateOpen Then
MsgBox "Connection Failed"
Exit Sub
End If

set dbasers =
End Sub

can you help with some explaination...
many thanks in advance
bob.G
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top