Message from discussion Access

From: Paul Clement <UseAdddressAtEndofMess...@swspectrum.com>
Subject: Re: Access
Date: Thu, 08 Dec 2005 08:03:19 -0600
Message-ID: <pcegp1hau3p5v4vr1jknkakk0pu594fuql@4ax.com>
References: <55CFDB04-FF04-471F-B152-056C46537B3F@microsoft.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: microsoft.public.dotnet.framework
NNTP-Posting-Host: 198.153.224.200
Path: g2news1.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Lines: 1         

On Wed, 7 Dec 2005 11:57:02 -0800, "John Thompson" <JohnThomp...@discussions.microsoft.com> wrote:

¤ OK,
¤ 
¤ I have an access addin.  On startup, I can open my database and enumerate 
¤ the tables in the database:
¤ 
¤ ...
¤ myApp = (Micorsoft.Office.Interop.Access.Application) application;
¤ myApp.OpenCurrentDatabase("c:\\mydatabase.mdb");
¤ foreach (Microsoft.Office.Interop.Access.AccessObject ao in 
¤ myApp.CurrentData.AllTables)
¤ {
¤   System.Windows.Forms.MessageBox.Show(ao.Name.ToString());
¤ }
¤ 
¤ My question is, once I have the particular table that I want, how do I 
¤ add/delete a record from it?  It seems like a pretty easy task, but I can't 
¤ find an example anywhere or documentation anywhere.

Use ADO.NET with simple insert and delete SQL statements:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskCreatingConnectionToAccessDatabase.asp


Paul
~~~~
Microsoft MVP (Visual Basic)