Help,
This is driving me mad.
I am trying to connect to a database using User Level Security.
I am setting the table name in code as below:
NewTabName = "tblIcons"
i have the following code so far:
'reattach table from new database
Set tbl = db.CreateTableDef(NewTabName)
tbl.Connect = (";DATABASE=" & Directory & ";UID=RileyM;PWD=RileyM;")
tbl.SourceTableName = NewTabName
db.TableDefs.Append tbl
The code errors on the last line shown and produces an error along the lines of:
Could not read definitions; no read definitions for tblIcons.
Any ideas what the problem is. am i formatting the code incorrectly?
This is driving me mad.
I am trying to connect to a database using User Level Security.
I am setting the table name in code as below:
NewTabName = "tblIcons"
i have the following code so far:
'reattach table from new database
Set tbl = db.CreateTableDef(NewTabName)
tbl.Connect = (";DATABASE=" & Directory & ";UID=RileyM;PWD=RileyM;")
tbl.SourceTableName = NewTabName
db.TableDefs.Append tbl
The code errors on the last line shown and produces an error along the lines of:
Could not read definitions; no read definitions for tblIcons.
Any ideas what the problem is. am i formatting the code incorrectly?
