In Access 2000, how do i insert a new row in the middle of my tab.

C

cpcelton

we use Access 2000 and have in the past had no problems adding a row in the
middle (anywhere but the end, not adding a new record) to a table by
highlighting a row and then right clicking and selecting add row or going up
to the insert key at top but for some reason we now cannot do it. has anyone
else had this problem and do you know how to get around it? thanks.
 
R

Rick B

The order of records in a table is irrelevant. The table is simple a
storage place (a "bucket") used by Access. Your users should NEVER even see
the tables.

If you care about the order, then you should be working in a form, query, or
report and then sorting on some field.

Hope that helps,

Rick B
 
L

Larry Daugherty

You shouldn't be mucking about in the tables directly so it's a
non-problem. Use forms and queries to enter and massage data!

HTH
 
Top