Table records getting populated randomly instead of starting from 1st row in table

[ashishkarapurkar]

HI,



I am a novice in access.While importing table into a new/empty access database , the records are getting populated from any random row far below instead of starting from 1st row.Can someone please guide on what to do?

[Minty]

Unless you make an order by clause when selecting the records, they have no specific order in a table.

Even when in the table they are only displayed in a an arbitrary order, unless you have told access to display them in a specific order.
If you need records in a specific order then you have to have something that can control that order. TimeStamp or similar.

Ordered record sets are what queries are for.

[ashishkarapurkar]

HI Minty,

It is not about order in a table.What i mean to say is i have an empty table and now when i import data with 100 rows for first time , the data is populating from row number 1000 to 1100 instead of row 2 to row 102.any solution for that.

[June7]

Since this is an autonumber field, the sequence of numbers and gaps should not matter. Only purpose is to provide a unique identifier for each record.

[CJ_London]

does your table have an autonumber field? and is that what you are referring to here 'row number 1000 to 1100 instead of row 2 to row 102'. If so, this is normal behaviour. It is not a row number, it is a unique identifier for the record and as such has no meaning beyond that (such as row number, order of insertion, etc).

[isladogs]

Ajax beat me to it ....
Autonumber fields will start from the previous record value +1 ...even if the previous record has been deleted
So if you now have records 1000 to 1100, next import will start at 1101

You can reset the autonumber 'seed' by compacting the database but the number has absolutely no meaning other than as a unique identifier as Ajax stated

[Micron]

if in fact this is about autonumbers, suggest you read http://www.utteraccess.com/wiki/Autonumbers