Message from discussion
Access
Thread-Topic: Access
thread-index: AcX8EiDOkRphMDveQgOXxZtjvPog3w==
X-WBNR-Posting-Host: 208.20.220.72
From: "=?Utf-8?B?Sm9obiBUaG9tcHNvbg==?=" <JohnThomp...@discussions.microsoft.com>
References: <55CFDB04-FF04-471F-B152-056C46537B3F@microsoft.com> <pcegp1hau3p5v4vr1jknkakk0pu594fuql@4ax.com>
Subject: Re: Access
Date: Thu, 8 Dec 2005 08:12:04 -0800
Lines: 38
Message-ID: <FF027E80-0F79-435B-A67E-B3FB4024B4D4@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
Thanks Paul. I suppose I should have spent a while more navigating through
MSDN. Regardless, that's what I needed.
Thanks again,
-- John
"Paul Clement" wrote:
> 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)
>
|
