VBNET2005 : Manipulating MS Access tabledefinitions in VB.NET -> Create, Copy and Drop Table.

  • Thread starter Screaming Eagles 101
  • Start date

Screaming Eagles 101


I have an Access MDB database with a Table1.
From VBNET I would like to CREATE a NEW table, which is a copy of Table1,
but not with the Data, only the definition.
I would also like to have the possibility to DROP a table in that Database.

Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi


Do some searches in the comp.databases.ms-access newsgroup for "create
tables." After you have some sample code just add a reference to access
and .Net and you should be set.


Seth Rowe

Michel Posseth [MCP]

Access as database backend is considered obsolete , so i guess that ADOX
is never going to be ported to ADO.NET

so i guess you only have 2 options

option 1

Set a reference to Adox and use it with COM interop to manipulate an Access

option 2

Use DDL SQL on a command object


Michel Posseth [MCP]

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question