My access database stopped saving the data that I enter, why?

J

jhowk

My database has worked perfectly for some time, but now when I enter data, it
will appear to be stored in the table, but when I close the database and
reopen it, its gone. Anyone know why or what I should do?
 
R

Roger Carlson

Are you certain it's gone? Or is it just perhaps somewhere else in the
table and not at the end like you would expect? Access tables don't have
any intrinsic order, so you can't depend that new records will stay at the
bottom unless you put some sort order on it that enforces it. Is it
possible you've saved your table with a different sort order?

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
J

jhowk

You were right, the database was sorting everthing by date, so the new data
was up with the data from Sept of last year, thanks alot. I added a new
primary key that is an autonumber, that should fix the problem shouldn't it?

Thanks again
 
J

John Vinson

You were right, the database was sorting everthing by date, so the new data
was up with the data from Sept of last year, thanks alot. I added a new
primary key that is an autonumber, that should fix the problem shouldn't it?
Click to expand...

Not really.

A Table HAS NO ORDER. It's - usually - presented for your viewing in
Primary Key order but depending on where and how you're displaying the
table, you can't even count on that.

If you want to see data in order, *use a Query* with a sort term.

John W. Vinson[MVP]
 
J

jhowk

Thanks, we already have querys to retrieve the data, it just hadn't occured
to me to use them to see if the data was there or not.
 
R

Roger Carlson

John is absolutely right. There is no order in an Access table and it's
designed that way. Don't worry about order in the table. Base everything
off of queries.

But I want to add something here. The Access GUI can fool you into thinking
it stores records in some order. If you open a table, click a sort button,
then save the query, it will appear as if the table was saved in some order.
However, what it is really saving is a filter that will DISPLAY the table in
that order IN THE GUI. This order will not be imposed on any form based
directly on the table. Nor will it affect recordsets.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top