Add new table to ACCESS-database

From: Frans Vander Meiren (Meiren_at_discussions.microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 11:57:03 -0800

Hi

I'm working on a databaseproject. So, I start opening the database and for
some reasons I need to add a table to the database. Therefor I create a
DataTable en add it to a DataSet. Via the CommandBuilder I built the
necessary update commands. I ended with a:

      data_adapter.Update(data_set, "NewTable")

But nothing changed in the access database.

Thanks a lot
Frans

Relevant Pages

  • Re: Form quit, bypasses cancel in textboxes BeforUpdate
    ... Just about every pc database product. ... would love to find that shortcut, and the instant pain killer. ... >> have to resort to using the forms before update event). ... there is lots of reasons for the above: ...
    (microsoft.public.access.formscoding)
  • Re: 3vl 2vl and NULL
    ... >> number of NULLs to denote the various reasons why data can be missing. ... You, like any database, have only the values. ... >> fact at all for Uncle Vernon in the fact table for a person's age. ... >- My family member Aunt Marge has an age of 47 years. ...
    (comp.databases.theory)
  • Re: Error Message: Two few parameters, Expected 2
    ... reasons the records are not saving properly to the database. ... Here the sql statement is referencing the form for the susgrant ... >> Dim rst As Recordset ...
    (microsoft.public.access.modulesdaovba)
  • What does this NULL mean?
    ... The number of long threads about NULLs indicates that they are a source of difficulty and disagreement. ... All this situation is telling us is that there is no C value in the database for this value of A. It does not matter how many possible reasons there are for the existence of this situation, we do not know why there is no value. ... Actually presenting lots of possible reasons was a very bad argument because only if there was exactly one reason would we know what was going on. ... There is no guarantee that there is a single form of representation for each of the reasons, and hence no general way of implementing a NULL. ...
    (comp.databases.theory)
  • Re: Image Question
    ... > the database though... ... the advantages might be for storing them in the database. ... > somewhere on the server that had its record deleted). ... You gave "reasons" and so many times people just ...
    (microsoft.public.dotnet.languages.vb)