I have created a MYSQL database in PHPmyadmin; users add records via PHP pages. The ID is an autoincrement field, and one field (PRT) is a print flag, set by default to "1"
I use ODBC in MS ACCESS to link to the database, so I can print reports where the flag = 1; it then runs an update query to set the PRT field to "0"
The update works - but then I cannot add new records to the database; when I open it in PHPmyadmin the structure shows the autoincrement "next" record pointer is still at the last record - I can't even use the INSERT command to add records.
Any ideas? - help appreciated!
