Create Table in code

[Allen Browne]

DAO is best for creating tables. Here's an example showing the various field
types and properties:
http://allenbrowne.com/func-DAO.html#CreateTableDAO

It is also possible to use ADOX:
http://allenbrowne.com/func-ADOX.html#CreateTableAdox

Or you could use DDL:
http://allenbrowne.com/func-DDL.html#CreateTableDDL

 

[Brian]

Hello all, I need to create a table in code with dynamics columns.
Anyone do this before? can i see a sample many thanx

 

[stromo]

DAO is best for creating tables. Here's an example showing the various field
types and properties:
http://allenbrowne.com/func-DAO.html#CreateTableDAO

It is also possible to use ADOX:
http://allenbrowne.com/func-ADOX.html#CreateTableAdox

Or you could use DDL:
http://allenbrowne.com/func-DDL.html#CreateTableDDL

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Show quoted text -

Use simple html table tags instead of that industrious programs. Its
simple and and easy to use.

 

['69 Camaro]

Hi.

Use simple html table tags instead of that industrious programs. Its
simple and and easy to use.

This newsgroup is dedicated to Microsoft Access database questions about
queries. The only programming languages that can be used in Access are SQL
and VBA. While HTML may be simple, it's designed for Web applications and
is useless for creating Jet tables within Access database files.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.