A
Amy
Hi,
I have linked an oracle database in access and created a
form to update/add data to the database. However,
the 'ID' column in the database is in 'number' format.
1: How can I change this 'number' format to 'autonumber'?
I tried to do this in access, but i can't make any changes
to the table design because it is a linked table.
2: is there a way that i can use a code to populate
that 'ID' column automatically?
any ideas? TIA...
I have linked an oracle database in access and created a
form to update/add data to the database. However,
the 'ID' column in the database is in 'number' format.
1: How can I change this 'number' format to 'autonumber'?
I tried to do this in access, but i can't make any changes
to the table design because it is a linked table.
2: is there a way that i can use a code to populate
that 'ID' column automatically?
any ideas? TIA...