Thanks All
I was - in the end - able to sort my problem out after some Googling!!
As I said it was reporting a Duplicate Key but when I used DESCRIBE and
SHOW it told me there was NO Key!!
Using UPDATE I was able to re-set the KEY and all is now fine with
everything working as expected.
Le 27/03/2013 08:59, Ian Whitfield a écrit :
Hi Ian,
I have set-up a new MySQL Database, imported all my CSV data from my old
Database, Connected LO Base to this and designed my 'User Form'.
Everything is working fine _EXCEPT_ my 'User Form' seems to be stuck in
'Read Only' mode as I can not
Le 27/03/13 15:55, Mark Stanton a écrit :
Hi Mark, Ian,
I get HasPrimaryKey 0
What is stopping me setting the key or how do I get round this??!!
What is stopping the key being defined is probably the existence of data
in the table for the PRI field (autoincrement by any chance ?). You