Problems with JDBC and Referential Integrity

[Claire]

Wandering if anyone can advise me, I am a bit stuck. I have been working on
a project using JDBC
to connect to an access Database. This is all fine except when I enforce
referential Integrity! It will
not allow me to enter data into one table at a time as all the primary keys
need to be updated at
the same time. I thought that the Commit and Rollback methods would do the
job but this is also
sequential. Does anyone know how to get around this.

[alberto]

whe retreiving or updating remember to not use the

select * from table1
and when updating the fields update them as field1, field 2 etc..

if you are updating in a batch pre-select the batch first.--ae

"Claire" <rvzec_claire@yahoo.co.uk> wrote:
>
>Wandering if anyone can advise me, I am a bit stuck. I have been working
on
>a project using JDBC
>to connect to an access Database. This is all fine except when I enforce
>referential Integrity! It will
>not allow me to enter data into one table at a time as all the primary keys
>need to be updated at
>the same time. I thought that the Commit and Rollback methods would do the
>job but this is also
>sequential. Does anyone know how to get around this.