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
