Hi

Since the last version of my released software I've had to make some
modifications to the back end Access database such as adding an extra
field to a table and adding new queries.

Does anyone know the easiest way to modify a tables structure and add
queries using purely VB.NET or is it necessary to use COM objects to
do so?

Thanks


Lee

Lee,

Without creating you can do every thing with a database by executing
OleDBcommand.executenonquery and SQL statements.

(When those SQL are there for your need, however Altering is there).

I hope this helps,

Cor

On 30 Mar 2005 06:33:28 -0800, lee.otta***@v21.me.uk (Lee) wrote:

¤ Hi
¤
¤ Since the last version of my released software I've had to make some
¤ modifications to the back end Access database such as adding an extra
¤ field to a table and adding new queries.
¤
¤ Does anyone know the easiest way to modify a tables structure and add
¤ queries using purely VB.NET or is it necessary to use COM objects to
¤ do so?

You can probably use Access SQL DDL via ADO.NET for most operations:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

Excel and ADO.NET
return OleDbDataReader from static function
ado.net create a table
Patterns and Practices - SQL Database Question
Excel ADO question