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?

 

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

Michael,
Thanks, on reflection I ought to have known that.
--
Siv
Martley, Near Worcester, UK.

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