Hi @all,
I want to link a table of my Database dynamically on runtime. I use the
following code in my Access2007 DB
Dim tdf As DAO.TableDef
Set tdf = CurrentDb.CreateTableDef("tableName")
tdf.Connect = "ODBC;DRIVER=SQLite3 ODBC Driver;Database=C:\SQLite\MyDB.sqlite;"
tdf.SourceTableName = "LiteTabName"
currentdb.TableDefs.Append tdf
I always get the message "Error -7778;there is no message for this error"
I can link the table using the SQLite3 ODBC, but not with code. The driver and
the DB seems tob e absolutely ok
I hope some one can help me
Kind regards
Carsten
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
