I am somewhat new to database design, so this may be a silly question!
I have my 'mysql' database online, and am able to access it via ms access 2002.
My 'mysql' table has a primary key with autonumber. When I edit the data with access, i bypass the key coloum, and enter a value in the only other coloum. Upon moving to the next record, it replaces the record with:
however when I close the table view, and re-open it, the entered data is there?!
I assume that there is some parameter that I can set to re-initalise the table.
BTW a form does exactly the same thing?