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

[Guest]

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?

 

[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

 

[Baz]

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?

If you are viewing the data through a form, maybe it's DataEntry property
has got set to True somehow.

 

[Guest]

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

 

[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?

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]

 

[Guest]

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.

 

[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