create a table within an access2007 database using code in a vb.net app ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aussie Rules - 14 Feb 2008 07:58 GMT

Hi,

Is it possible to create a table via code (create table ........) in an
access 2007 database from a Vb.net 2008 application?

Any tips/samples/links on how to do this ?

Reply to this Message

Allen Browne - 14 Feb 2008 08:51 GMT

Assuming you have some kind of driver that connects to the Access database,
you can execute a DDL query to CREATE TABLE.

Here's an example of executing a DDL statement to create a table:
http://allenbrowne.com/func-DDL.html#CreateTableDDL
The example is VBA code, but the SQL statement would be similar in whatever
language and connection you use from VB.NET.

Signature

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.

> Is it possible to create a table via code (create table ........) in an
> access 2007 database from a Vb.net 2008 application?
>
> Any tips/samples/links on how to do this ?

Reply to this Message