Create Table from another Tables Properties? (A2k (9.0.4402) SR-1)

Topic

New Reply

Create Table from another Tables Properties?

A2k (9.0.4402) SR-1

How do I create a table that contains the following structure and properties from another existing table?

strTableName text
strFieldName text
strDescription text
strCaption text

Thanks, John Graves

Reply | Quote

Replies

John:

You could use the ADOX library to create the table and fields in code, or….Copy the existing table (Ctl – C), paste (Ctl – V), and choose to paste only the structure. I hope this helps.

Reply | Quote