Re: Access 97 application migration from MSSQL to MySQL backend

[Vernon Robinson]

I had the same issue. In the app I am beginning to work on, I have a numeric KeyField. I solved it by putting the keyfield for the table on the Access form and setting the default value of the control to the number Zero. You could make the control invisible and inactive to hide it on the form.

An easy way to test to see if your problem is the same as mine is to open the table view and enter the value of ZERO in the Keyfield for a new record you are trying to add. I am assuming a numeric keyfield is used to link the tables. If this is true then you should be able to add a new record without #deleted.



You could also set the default value to '=[Key Press]' in the default value of the Key Control. This seems to also work.

Good luck.