VBA - Controlling Access from Word: Create/copy table including lookup details
Posted on 2008-06-24
I need to be able to create or copy an Access table without opening the database. Thanks to the helpful response to a question I posted yesterday, I can now create the table. However, I need one of the fields to refer to another table (in the same database) as a lookup field. Is it possible to achieve this either as part of the initial creation process, by modifying it afterwards or by copying a master copy of the table? I've tried the DoCmd.CopyObject but this seems to require the database to be physically open which is not an option.
As always, many thanks in advance for any help.