Altering Access Database Using ADO.NET

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

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, (e-mail address removed) (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)
 
Back
Top