Hello,

I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.

In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to copy
the new one.

Is something similar possible with SQLEXPRESS.  I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table.  Is this possible through VB.NET code?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

hello Michel

You can do this with SQL -DMO objects or with DDL-SQL  ( wich suits you the
best )

regards
Michel   Posseth


"Michel Vanderbeke"  schreef in bericht
news:46c44d40$0$13858$ba620e4c@news.skynet.be...

> Hello,
>
> I have a program, running in several places, using SQLEXPRESS as database. 
> The different places are stand-alone, and not connected to a network.
> Regulary, I have to apply changes on certain tables of the database.
>
> In a previous program, written in VB6 with an Access database, I used JRO 
> through VB6-code to delete the table in the different databases and to 
> copy the new one.
>
> Is something similar possible with SQLEXPRESS.  I would like to be able to 
> update tables in an SQLEXPRESS database file by deleting them and replace 
> them with the new table.  Is this possible through VB.NET code?
>
> Many thanks and greetings from Brugge (Bruges - Belgium),
>
> Michel
>
>