Even easier than the approaches discussed... make a "template table" (empty,
no data) in your database then use CopyObject to copy the table, fields, and
all their properties to the other DB. An empty table doesn't increase the
size of your database a great deal and it eliminates a lot, really a lot, of
code.
And, of course, you can create those template tables with the visual table
designer.
Larry Linson
Microsoft Access MVP
"Dave" <(E-Mail Removed)> wrote in message
news:0ae601c35752$922fb240$(E-Mail Removed)...
> Hi,
>
> Can anybody suggest a method for creating a table in a
> database programatically from a different database, ie
>
> code in db1 creates a table in db2.
>
> ???
>
> Thanks in advance!
>
>
|
Similar Threads
