Need guidance--Using MSAccess Front with MySQL 1

[EdLentz]

I already have a MySql DB running and I am using some PHP to manipulate the data. I am in dire need to use a "Combo Box" such as usable in MS Access. I already have an Access front end (just starting it up actually) linked to the MySql DB. I am running into problems with the combo box producing a #DELETED field message after the "After Update" event. I can't seem to find a resolution to this. If I close the form and go back to it, the record is there. So the question is how do I get around this issue? I am only using Access for the combo box, it seems the easiest way to do what I want. JavaScript and Java is beyond me at the moment, I would much rather use them, but I have not the time to learn them. Any help is very much appreciated.

 

[dbernal99]

I got into the same problem. I found that if you use a timestamp field in your table in MySql will get the problem resolved. I tried myself and worked.

 

[EdLentz]

Thanks dbernal99 I'll give it a try