am trying to use Access '97 as the front end data entry piece for a database built on a MySQL server.
My problems are these:
Access does not read the Autonumber from the database as an AutoNumber - it seeeis as a plain number (long integer) therefore it does not write into the form when data is entered.
I have built several subforms in the main form to handle data entry into several tables. When I move from one part of the main form into the subforms, I get a #delete error in all fields in which data had been entered.
When I move to the next record - all prior data is deleted.
When I close the form and re-open it, some of the data reappears.
Most of the data correctly writes to the MySQL tables including the AutoNumber.
Can yopu shed any light on why these problems are occurring and how I might fix them?
I have built an autonumber primary key into every MySQL table, as Access it seems will not allow data entry fields in the form without them.
Any help you can provide would be greatly appreciated.
Thanks
My problems are these:
Access does not read the Autonumber from the database as an AutoNumber - it seeeis as a plain number (long integer) therefore it does not write into the form when data is entered.
I have built several subforms in the main form to handle data entry into several tables. When I move from one part of the main form into the subforms, I get a #delete error in all fields in which data had been entered.
When I move to the next record - all prior data is deleted.
When I close the form and re-open it, some of the data reappears.
Most of the data correctly writes to the MySQL tables including the AutoNumber.
Can yopu shed any light on why these problems are occurring and how I might fix them?
I have built an autonumber primary key into every MySQL table, as Access it seems will not allow data entry fields in the form without them.
Any help you can provide would be greatly appreciated.
Thanks
