Output Directory using Access 2003 DB

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Soddy
    #1

    Output Directory using Access 2003 DB

    Hello!

    I'm playing with an Access 2003 (Converted Northwind & Split) DB. I 'copy &
    paste' the split Access DB into the 'Solution' of C#.NET and make the
    'connection'. I then 'copy & Paste' the DB (from the original into the
    'Output Directory' of the Project - Debug). I then went into the
    Northwind_2003D ataset.xsd and changed the 'Copy to output directory' property
    to "Do Not Copy". I did this for the ...Designer.cs, ...xsc, and ...xss
    files. I then tested (used the datagrid control on the form) to add a 'row'.
    I could type the info okay into the new row (the 'save' button was not there
    - I assumed it is because I'm not using a connection to a remote DB). I
    assume that when I 'tab' or 'enter' off this line that the new row is saved
    to the DB. I then closed the app and re-opened it and this 'new' row doesn't
    show... So, I must be doing something wrong somewheres...

    Thanks in advance...!!

    --
    Thanks!
    Soddy
    Tags: None
    • Shailen Sukul
      #2
      RE: Output Directory using Access 2003 DB

      It seems to be over-writing your database on every build. Set the "Copy to
      putput dir" property for the database to "copy if newer".
      --
      Good luck!

      Shailen Sukul
      Architect
      (BSc MCTS, MCSD.Net MCSD MCAD)
      Ashlen Consulting Service P/L
      (http://www.ashlen.net.au)


      "Soddy" wrote:
      Hello!
      >
      I'm playing with an Access 2003 (Converted Northwind & Split) DB. I 'copy &
      paste' the split Access DB into the 'Solution' of C#.NET and make the
      'connection'. I then 'copy & Paste' the DB (from the original into the
      'Output Directory' of the Project - Debug). I then went into the
      Northwind_2003D ataset.xsd and changed the 'Copy to output directory' property
      to "Do Not Copy". I did this for the ...Designer.cs, ...xsc, and ...xss
      files. I then tested (used the datagrid control on the form) to add a 'row'.
      I could type the info okay into the new row (the 'save' button was not there
      - I assumed it is because I'm not using a connection to a remote DB). I
      assume that when I 'tab' or 'enter' off this line that the new row is saved
      to the DB. I then closed the app and re-opened it and this 'new' row doesn't
      show... So, I must be doing something wrong somewheres...
      >
      Thanks in advance...!!
      >
      --
      Thanks!
      Soddy

        Comment

        • Soddy
          #3
          RE: Output Directory using Access 2003 DB

          Hello!

          Thanks for the response...! I finely figured out what I was doing wrong in
          my VB.NET app and so will apply it to here. The procedure to do this
          scenario was not real clear to me and so I tinkered some more and found out I
          had the DB setup wrong...

          --
          Thanks!
          Soddy


          "Shailen Sukul" wrote:
          It seems to be over-writing your database on every build. Set the "Copy to
          putput dir" property for the database to "copy if newer".
          --
          Good luck!
          >
          Shailen Sukul
          Architect
          (BSc MCTS, MCSD.Net MCSD MCAD)
          Ashlen Consulting Service P/L
          (http://www.ashlen.net.au)
          >
          >
          "Soddy" wrote:
          >
          Hello!

          I'm playing with an Access 2003 (Converted Northwind & Split) DB. I 'copy &
          paste' the split Access DB into the 'Solution' of C#.NET and make the
          'connection'. I then 'copy & Paste' the DB (from the original into the
          'Output Directory' of the Project - Debug). I then went into the
          Northwind_2003D ataset.xsd and changed the 'Copy to output directory' property
          to "Do Not Copy". I did this for the ...Designer.cs, ...xsc, and ...xss
          files. I then tested (used the datagrid control on the form) to add a 'row'.
          I could type the info okay into the new row (the 'save' button was not there
          - I assumed it is because I'm not using a connection to a remote DB). I
          assume that when I 'tab' or 'enter' off this line that the new row is saved
          to the DB. I then closed the app and re-opened it and this 'new' row doesn't
          show... So, I must be doing something wrong somewheres...

          Thanks in advance...!!

          --
          Thanks!
          Soddy

            Comment

            Previous template Next
            Working...