Insert Rows HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,
I had to enter an old database in Access 2003. OK.
I realised that there are problems with the number and the automatic numbers
as the members who didnt pay their membership were deleted while keeping the
rows. this created a mess in the data base. I work with the tabkes since i am
familiar with them. Now I am trying to isert rows in the places where
continous numbers should be and adjust the numbers but it seems impossibel as
Access doesnt allow me to insert new rows in the middle of the table.

any ideas?
many thanX in advacen,
niki
 
Autonumbers are simply keys used to make sure each record has a unique
number.

They should not be used for anything meaningful and should not be seen by
your users.

If you want a meaningful number for your "memberID" then you DON'T use an
autonumber field. You use a number field.

I guess the biggest question here is why do you care if there are gaps?
People will leave. Just ignore the gaps.

Also, you indicate you want to INSERT rows in your table. Access is not a
spreadsheet. The data in the table is just a heap of data. The placement
of records is not important in the table. You can determine the order
records appear in your FORMS, QUERIES, or REPORTS. Don't worry about the
table order. You can't successfully control it. Generally, you should
NEVER work in the tables once you get the database built. Tables are
storage buckets, not user interfaces.
 
Back
Top