Access - microsoft.public.dotnet.framework

Message from discussion Access

John Thompson

View profile

More options 8 Dec 2005, 16:12

Newsgroups: microsoft.public.dotnet.framework

From: "John Thompson" <JohnThomp...@discussions.microsoft.com>

Date: Thu, 8 Dec 2005 08:12:04 -0800

Local: Thurs 8 Dec 2005 16:12

Subject: Re: Access

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

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/vbco...

> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Reply to author Forward