Hi,

Who can help me ?

I want to use an ODBC connection to an MSAccess database (data.mdb). I have this code for and it works well for my SQL-Server but it doesn't work for my ODBC connection with the MSAccess database (data.mdb). I always get RUN-TIME error 3423 (you cannot use ODBC to ....)
What is wrong ?


R@emdonk

The Code:

Private Sub stored_procedure_ODBC()


Dim str_SQL, Connect$, int_teller, db_data, rs_data


str_SQL = "select * from dbo_Student_List"


Connect$ = "ODBC;DSN=data;UID=;PWD=;DATABASE=data;"
Set db_data = OpenDatabase("", False, False, Connect$)
Set rs_data = db_data.OpenRecordset(str_SQL, dbOpenDynaset, dbSeeChanges)


rs_data.MoveLast
int_teller = rs_data.RecordCount

MsgBox int_teller


End Sub