Changing auto ID numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H...E...L...P

I am trying to change the auto ID numbers in the data base, thats Customer
ID and Product ID to a manual system. I don't want to use sequential numbers.
Does anyone know if this is possible and how we remove the auto formatting
for these areas?

I am lost.
Alan
 
If you want to permanently change the AutoNumber field into one where you
can type a number:

1. Open the table in design view.

2. Change the Data Type column beside this field from:
AutoNumber
to
Number.

3. Remove the 0 default value in the lower pane of table design.

4. Save the table.
 
Back
Top