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

17 Oct 2006 9:17 AM

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
-------------------------------------------------

17 Oct 2006 9:59 PM

rowe_newsgroups

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

Screaming Eagles 101 wrote:
Show quoteHide quote

> 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
> -------------------------------------------------

26 Oct 2006 1:43 PM

DK

Try something like this:

Select * INTO Table2 from Table1 where 1 = 2

Screaming Eagles 101 wrote:
Show quoteHide quote

> 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
> -------------------------------------------------

12 Nov 2006 6:10 PM

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
database

option 2

Use DDL SQL on a command object

regards

Michel Posseth [MCP]

Show quoteHide quote

" Screaming Eagles 101" <see_my_site@online.please> schreef in bericht
news:KdSdnWYkCKdkAqnYnZ2dnUVZ8qCdnZ2d@scarlet.biz...
> 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
> -------------------------------------------------
>
>