insert a row in .mdf table

[Guest]

hi, i wanted to insert a row in a table but when i insert row it
automatically goes to the bottom ( near auto number)

 

[Rick B]

That is correct.

The order in the table is irrelevant. Table data is not stored in any
particular order. You seem to be confusing a database with a spreadsheet.

Your sorting comes into play when you create a query, form, or report. In
those objects you can define which field you'd like to use to sort.

Rick B

 

[SteveW via AccessMonster.com]

It is quite correct that it is irrelevant to the database as to which row
any particular order data is stored, but Access does allow you to insert a
row wherever you want it. Click the cursor on the row where you want to
insert a row, click the right mouse button and select 'Insert Row'.
However, only do one row at a time or you are likely to lose data.