How can I cange autogenerted id fields

  • Thread starter Thread starter Alfred Cavill
  • Start date Start date
A

Alfred Cavill

I wish to change auto generated ID fields when my Database has to be
altered. (ie records removed or database exported). Does anyone have any
ideas please.
 
You can't change the value of an AutoNumber field, but then you shouldn't
need to.

The only point of an autonumber field is to provide a (practically
guaranteed) unique value that can be used as a primary key. No meaning
should be assigned to its value: in fact, it's unusual to have the value of
an autonumber field shown to the user. Autonumber fields are not guaranteed
to be sequential: if you start to save a record and change your mind, the
value that would have been used is lost. In fact, if you use Replication to
synchronize multiple copies of the same database, your Autonumber fields
would be random.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I Manually Change Access Primary Key ID Fields ? 2
Data Entry Form and Auto Number ID 2
Static IDs in autonumbered lookup tables 3
Special characters 3
Nested query problem 6
Auto Number ID Field 4
Access 2000: ID autonumber dillemma 7
microsoft access SEARCH by "ISSUE ID" 5

Back
Top