Invalid Argument - TableDefs.Append

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top