Anyone know of any fixes to the following problem?

I'm trying to programmatically attach an Access table to the current Access
database.  I've created a tabledef with the following statement:
        Set tdf = db.CreateTableDef("tblTable", dbAttachedTable, "tblTable",
";DATABASE=C:\ACCESS\TEST1.MDB")

However, when the code runs, I get an "Invalid Argument" error.  The
dbAttachedTable constant is part of the Microsoft DOA 3.0 Library that
comes with MS Access.

Thanks for your help!

C Whisman

Hi "Office Development"

In Access 2.0 you could specify this and it wouldn't cause any
problems. In Access 97 you must NOT specify 'dbAttachedTable' or else
you get the error you reported.

Try leaving that argument off.

-- Jim Ferguson, FMS
   http://www.fmsinc.com