Search results

  1. K

    problem with odbc connection or vba code

    for some kind of reason doing an DAO.Database gives me errors. i solved my problem using an adodb.connection and i managed to create my table. i used this code: Private Sub cmdadodb_Click() Dim db As ADODB.Connection Set db = New ADODB.Connection db.ConnectionString = "Driver={MariaDB...
  2. K

    problem with odbc connection or vba code

    i have done that already and i get error 3032 Private Sub cmdCreateTable_Click() Dim sql As String 'On Error Resume Next 'DoCmd.DeleteObject acTable, "Zita_Db_Test" 'On Error GoTo 0 sql = "CREATE TABLE [Zita_Db_Test] ([LAST NAME] VARCHAR(255), [FIRST NAME] VARCHAR(255), " & _ "[TAX...
  3. K

    problem with odbc connection or vba code

    Hey everyone, hope you guys can help me. i have established a dao connection to my localhost (think so) and i am having problem creating a table in that database. my problem is in this code: Option Compare Database Option Explicit Dim db As Dao.Database Dim rs As Dao.Recordset Dim Conn...
  4. K

    Hello AWF

    Hello everyone, I am new to this forum but i can say that i am a bit more than beginner in ACCESS and VBA. I been reading your forum to find solutions for my database for a long time now. but i am on a dead end concerning odbc dao connection to my database, will post soon on modules vba...
Top Bottom