hi. can you please help me out with this program im writing.
its a simple log in system written in vb6 .
ms access is my database.
i have a problem with connecting vb to access.


heres the code:

/codes for module
Public db As ADODB.Connection
Public rec As ADODB.Recordset

Sub connect()
    Set db = New Connection
    db.CursorLocation = adUseClient
    db.Open "Provider = Microsoft.jet.OLEDB.4.0;data source = letmein.mdb;persist security info = false"
    
End Sub


/codes for the form
Private Sub Form_Load()
connect
sql = "select * from user"
Set rec = New Recordset
rec.Open sql, db, adOpenDynamic, adLockBatchOptimistic
End Sub

try to rename the table to something else.

USER is predefined keyword.

try to rename the table to something else.

USER is predefined keyword.

thank you so much sir!
:D im new to this.
thaaanks! :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.