Create back-end table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is it possible to create a table in a back-end database using code that is
run at the front-end?

Regards,
Ron.
 
Yes, it's possible if you OpenDatabase, and CreateTable. See help on
CreateField and CreateIndex as well.

While it is possible to use a DDL query statement to insert the table into
the back end, that's not really good enough for any serious table, as you
cannot set crucial properties such as the SubDatasheetName of the table, or
the AllowZeroLength property of the fields.

For the field types you need in your DAO code compared to the names in the
interface, see:
Field type names (JET, DDL, DAO and ADOX)
at:
http://allenbrowne.com/ser-49.html
 
Back
Top