HTML Page

  • Thread starter Thread starter Pras
  • Start date Start date
P

Pras

Hi,

I have a HTML page designed to update the database. Table has total 120
entries. ID field is the Primary key so their are total 120 ID. Now when i
add a new entry it shows 121 in id field but when i click on save it changes
the ID no. and assigns 65327 and so on. Could any one please asist me on the
same.
 
Apparently your autonumber has been changed from sequential to random. It
there is only 1 table, delete and recreate it with the same name.

If you have related tables, you are probably better off leaving it alone and
living with the random ID. IDs are really designed to maintain relationships
between tables, not provide any human readable meaningful data.
 
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

Creating a Default Value 1
Queries, Reports, and Maybe Some Database Design 0
Access Click in Table to Open Form 0
Default Field Value 3
Relationships and Keys 18
Primary Key Autonumber - Is it the best choice for discrete ID num 11
Count total records by date 1
Avoiding Duplicate Entries 4

Back
Top