J
Joshua Mouch
Some of our clients are experiencing problems after
updating to Windows 2000 SP4 (which includes Jet 4.0
SP7.0). Specifically, they are receiving an "Invalid
Argument" error on the line that contains
TableDefs.Append. We are linking from an Access 2000
front-end to another Access 2000 database.
Sample Code:
'sTableName is passed in as a string
Set db = CurrentDb()
Set tdf = New TableDef
db.TableDefs.Delete sTableName
tdf.Name = sTableName
tdf.SourceTableName = sTableName
tdf.Connect = msConnect ';DATABASE={path to database}
tdf.Attributes = dbAttachSavePWD
db.TableDefs.Append tdf
updating to Windows 2000 SP4 (which includes Jet 4.0
SP7.0). Specifically, they are receiving an "Invalid
Argument" error on the line that contains
TableDefs.Append. We are linking from an Access 2000
front-end to another Access 2000 database.
Sample Code:
'sTableName is passed in as a string
Set db = CurrentDb()
Set tdf = New TableDef
db.TableDefs.Delete sTableName
tdf.Name = sTableName
tdf.SourceTableName = sTableName
tdf.Connect = msConnect ';DATABASE={path to database}
tdf.Attributes = dbAttachSavePWD
db.TableDefs.Append tdf