save problem

  • Thread starter Thread starter The Badger
  • Start date Start date
T

The Badger

Hi there,
I am having a problem with Microsoft Access not saving new
records that I add to the end of my database. I enter a
couple of records, click save, close the db, and when I
try to re-open it, the records are gone. Anybody have an
idea what's going on?
thanks,
Dave
 
Hi

How are you entering the records? via a form? directly into the table?
How do you assure yourself that the records are gone? Any error message?

In an Access table, records are kept in no particular order. You may think
that you have inserted the records at the bottom, but those records may not
show up at the bottom the next time you open the database.

Immanuel Sibero
 
Hi,
you're right, the records were just getting inserted at
the front of my table. Do you know how I can make it so
that the records will just insert one at a time at the end
of the table?
Thanks,
Dave
 
Dave,

An access table is just a "bucket of records" (borrowing a term that's
commonly used here). When entering records into a table, there is rarely any
reason for records to be in any particular order. In fact, the common method
of entering records is via a form which display only the record being
entered, the other records are not even visible (so it doesnt matter what
order they are in).

You didnt indicate how you're entering the records. Are you entering
directly into the table using datasheet view?


HTH,
Immanuel Sibero
 
I'm using a pretty basic form to insert data into the
table. But one of my fields has a number that is a part
of a folder name that I need to increment by one as I move
down the table. For some reason Access stopped
automatically assigning an ID # to the records I enter in,
so anything I put in the table via my form gets inserted
by order of the wrong field. Do you know how I can turn
the auto ID thing back on?
Thanks,
Dave
 
I'm using a pretty basic form to insert data into the
table. But one of my fields has a number that is a part
of a folder name that I need to increment by one as I move
down the table. For some reason Access stopped
automatically assigning an ID # to the records I enter in,
so anything I put in the table via my form gets inserted
by order of the wrong field. Do you know how I can turn
the auto ID thing back on?
Click to expand...

Was the "auto ID" an Autonumber?

Note that the Form will display records in an arbitrary,
uncontrollable order if it's based on a Table. It might show them in
order of the Primary Key; it might not, depending on how Access can
get the records to the screen most efficiently. If you want to see the
records in ID # order you should base the form on a Query, sorting by
that field.
 
Back
Top