MS Access tables troubleshoot

Originally Posted by angelledagain

Hi there i use MS access to manage a small amount of data but i'm getting annoyed by my basic table structure.

i recently replaced all the data in the table with new data, but now i am adding new records.

thing is, tables normally default back to their original settings and layout when you enter and exit, but for sme reason, new records are appearing at the TOP of the table, instead of at the bottom.

i can re sort the table (TableID = ascending) but as soon as i refresh the table, the new records go to the top and away from other more recent records. really annoying.

can anyone help. i DO NOT want to use a query, i have plenty of those. i want my basic table to default back to the original order.

cheers
alison

Originally Posted by angelledagain

Hi there i use MS access to manage a small amount of data but i'm getting annoyed by my basic table structure.

i recently replaced all the data in the table with new data, but now i am adding new records.

thing is, tables normally default back to their original settings and layout when you enter and exit, but for sme reason, new records are appearing at the TOP of the table, instead of at the bottom.

i can re sort the table (TableID = ascending) but as soon as i refresh the table, the new records go to the top and away from other more recent records. really annoying.

can anyone help. i DO NOT want to use a query, i have plenty of those. i want my basic table to default back to the original order.

cheers
alison

Originally Posted by JustJim

Haven't seen that before, how are you adding records? It really shouldn't matter though because a table is just a bucket to hold data. Then you use queries or recordsets to gather and organise the data and forms or reports to present it to your users.

Sorry, just realised I was pontificating... How are you adding records? That may hold the key.

Jim

Originally Posted by JustJim

Bump

Sorry all - I'm away from work and away from home and can only get intermittent access to the 'Net. Can anyone field this for me?

Originally Posted by puppydogbuddy

Sounds like your table indexes are corrupted. Place the table in design view; click the index button on the toolbar;delete the indexes (including Primary Key);save; then re-add the indexes; save; test and see if that helped.

Originally Posted by angelledagain

OH DEAR

i just did that. and the table reorded itself completely randomly when appended to the new table. now the chronology i had in place due to it's sequence is destroyed. now i need to restore from backup tape.

and it seemed such a good idea (!!)

Originally Posted by puppydogbuddy

I told you to delete the primary key index, not the primary key itself. The autonumber primary key should still be there. All you have to do is sort by the key before you rebuild index. So delete indexes again; order the table by the key value using sort button, then rebuild indexes.

Originally Posted by angelledagain

did that, and it still filters randomly in a non sequential manner. forget it - it's clearly difficult to identify without seeing how oddly it's behaving in the flesh. i'll rebuild using an old format that didn't have this problem and update my data.

and yes, i've reorderd by autonumber and saved, that didn't help.

thanks everyone.
alison

Originally Posted by angelledagain

none of these meausre seem to work. this same problem is happening to many number of tables, it's not a corruption it's a constant problem and in fact, even when there is a primary ID number autonumbered which has been created from scratch, changing the filter will do incredibly strange things to just those few records. you all sound so terribly knowledgable and full of bright ideas, any chance someone can replicate a new table in MS access, as i've indicated and see what they come up with? all these suggestions are pretty random.

after all, you're the experts!
thanks