Can New fields be added to Access DB using System.Data?

[Siv]

Hi,

I would like to add some functionality to an existing VB.NET 2003
application so that I can add new fields to the application's database (MS
Access mdb), rather than having to get the users to return their data files
for conversion. The application is run on standalone PCs that are not
connected to any network other than the Internet. The current installation
uses System.Data and I would prefer not to have to get the users to install
ADOX. The majority of users don't have the MS Access application installed
so I can't use COM to control MS Access and do it that way.

Is there a way to do it or must I use ADOX?

--
Siv
Martley, Near Worcester, UK.

[m.posseth]

Hello

you can add , delete columns , indexes with DDL sql ( i did a project
like this on a Access 2000 DB )

just execute your DDL statement on the oledb command object

regards

Michel Posseth
"Siv" <ms**********@r emoveme.sivill. com> schreef in bericht
news:eY******** *****@TK2MSFTNG P15.phx.gbl...

Hi,

I would like to add some functionality to an existing VB.NET 2003
application so that I can add new fields to the application's database (MS
Access mdb), rather than having to get the users to return their data
files for conversion. The application is run on standalone PCs that are
not connected to any network other than the Internet. The current
installation uses System.Data and I would prefer not to have to get the
users to install ADOX. The majority of users don't have the MS Access
application installed so I can't use COM to control MS Access and do it
that way.

Is there a way to do it or must I use ADOX?

--
Siv
Martley, Near Worcester, UK.

[Siv]

Michael,
Thanks, on reflection I ought to have known that.
--
Siv
Martley, Near Worcester, UK.
"m.posseth" <po*****@planet .nl> wrote in message
news:eY******** ******@TK2MSFTN GP09.phx.gbl...

Hello

you can add , delete columns , indexes with DDL sql ( i did a project
like this on a Access 2000 DB )

just execute your DDL statement on the oledb command object

regards

Michel Posseth
"Siv" <ms**********@r emoveme.sivill. com> schreef in bericht
news:eY******** *****@TK2MSFTNG P15.phx.gbl...

Hi,

I would like to add some functionality to an existing VB.NET 2003
application so that I can add new fields to the application's database
(MS Access mdb), rather than having to get the users to return their data
files for conversion. The application is run on standalone PCs that are
not connected to any network other than the Internet. The current
installation uses System.Data and I would prefer not to have to get the
users to install ADOX. The majority of users don't have the MS Access
application installed so I can't use COM to control MS Access and do it
that way.

Is there a way to do it or must I use ADOX?

--
Siv
Martley, Near Worcester, UK.