Output Directory using Access 2003 DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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_2003Dataset.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...!!
 
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)
 
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...
 
Back
Top