Auto Increment UniqueIdentifyer MySQL

[YvonneNina]

Dear all,
I have exported an Access Database into SQL. Apparently no problem. I had a primary key field that autoincremented, which I exported to MySQL.
The problem is: when I create new Data with my Access frontend, the record will appear only after closing and reopening the table.
Why does the auto increment field not automatically auto increment. Is there a function to do this?

Any help very welcome, YvonneNina

 

[Broccoli2]

Have you included a timestamp column in your table? Are you viewing the data through a form?

-Rob

 

[YvonneNina]

I have no timestamp column and I am reviewing the data through a form.