Hi, I'm having trouble getting a database to keep changes made to it. As a starting point, I'm using the help "to do this" screens, and am following the instructions given. All is well until the test database created by the instructions is to be saved by clicking on the icon. No error messages appear, but the database doesn't update either. When I restart the project, the datagrid shows only the data prior to the update.

There must be something simple wrong, but I can't get a handle on it. There's no sense for me to start developing the code I really want to work on until the machine can write a database to begin with.

Thanks, Pat Ciferri

Hi there.. are you using a transaction???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo, thanks for the reply.

I'm an amateur radio operator, and I want to write a program that will allow me to keep track of the contacts I make during contests. I had tried to do that, but couldn't make my database changes work.

Before I spent lots of time on that, I decided to test the machine by stepping through the "how to" screens to make sure it can write, read, and update a sample table. Everything goes just as the "how to" topics says they should. Part of that sequence is to create and populate a table using the built in database creation program. But, when the instructions call for updating the sample table via a .Net program containing a datagrid, the data can be changed on the screen, but doesn't get updated when saved.

In regards to your question, I'm not doing a transaction, or for that matter, writing any code as part of the "how to" instructions.
It has to be something very simple, but I've checked everything I can think of, and even had a fellow from work who maintains our network and servers look at it, but even he can't figure it out. I'd be very interested in any insights you might have.

Thanks, Pat

ok.. are you doing a desktop application?? ( i think so but i have to check). What database are you using?? is inside your project?? if you have your database in a data folder, VB will copy it every time you run the project, so you will lost changes every time you try it... maybe that is happening to you?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========