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

  • Thread starter Thread starter Screaming Eagles 101
  • Start date Start date
S

Screaming Eagles 101

Hi,

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.

--
Filip
http://www.ww2airborne.net/
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.

Thanks,

Seth Rowe
 
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
database

option 2

Use DDL SQL on a command object

regards

Michel Posseth [MCP]
 
Back
Top