Hi there,
I'm trying to update a row of data in a table in an Access database from a Java Application. First it wouldn't work because I had related data in other tables. Changed relationships in database so that it will "cascade update related fields". It now allows me to update data that is not related to another table. When I go to update data that is related to another table, there is no error but no update happens. If I go to the database and do the update manually it works and changes all the data correctly in all the tables. Anyone got any ideas? I'm not even sure if is an sql, jdbc or access problem?
Thanks very much, appreciate any help.
BD
I'm trying to update a row of data in a table in an Access database from a Java Application. First it wouldn't work because I had related data in other tables. Changed relationships in database so that it will "cascade update related fields". It now allows me to update data that is not related to another table. When I go to update data that is related to another table, there is no error but no update happens. If I go to the database and do the update manually it works and changes all the data correctly in all the tables. Anyone got any ideas? I'm not even sure if is an sql, jdbc or access problem?
Thanks very much, appreciate any help.
BD