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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to